Results 1 to 4 of 4

Thread: Copying between worksheets

  1. #1

    Copying between worksheets



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Any one know how I can copy formulas between worksheets and have them automatically update to the new worksheet?
    Eg. I have =SUMIF(AA:AA,"=Closed",Q:Q) on worksheet 1 and I want to have the exact same formula on worksheet 2 and it automatically use the data in the cells in worksheet 2.

    I have 10 worksheets that all need the same formula and when I copy and paste all the values/codes change to #REF

    thank you


    Holly

  2. #2
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,704
    Articles
    0
    Excel Version
    2010 on Xubuntu
    If all the sheets are in the same workbook, no need to copy.
    If they are contiguous : while holding down the Shift key click the first and
    the last tab. All tabs are now highlighted
    If they are not, while holding the Ctrl key, select the tabs you need

    Then, in both cases, enter your formula in the first sheet. It will now appear on all the selected sheets in the same cell
    Right click on of the selected tabs and click " ungroup sheets". That's it

    PS I'm not sure if using entire columns is a good idea
    Thank you Ken for this secure forum.

  3. #3
    Thank you!

  4. #4
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,704
    Articles
    0
    Excel Version
    2010 on Xubuntu
    You're welcome
    Thank you Ken for this secure forum.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •