Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 6 of 6

Thread: Copy Formula To Different Worksheet & Reference That Sheet

  1. #1
    Join Date
    23rd August 2007
    Posts
    88

    Copy Formula To Different Worksheet & Reference That Sheet

    Hello,

    Currently I have a worksheet which is organized to have two pages on it. I will try to explain, i.e. imagine one page of the worksheet in the hypothetical range of A1:D26, then another page in the range E27:K50. So it is staggered on the same sheet. Is there an easy way to copy the range of E27:K50 onto another worksheet.

    Aside from the regular copy and paste, I am having problems because there are formulas in the 2nd range (E27:K50) which loose their references once copied.
    i.e the formula SUM(A1:A10) I would like to be SUM('Master List'!A1:A10) on the new sheet. Is there an easier way then going through all the formulas and adding the master list part.

    Elliott

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    15th April 2003
    Location
    USA
    Posts
    7,433

    Re: Referencing Formulas Between Worksheets

    If you CUT and then Paste, Excel 2003 is smart enough to do what you are asking. I don't know about Excel 97. Try it and see/
    Please do not U2U (private message) me directly for questions that should be posted to the forum; any such U2Us will be ignored.

  3. #3
    Join Date
    23rd August 2007
    Posts
    88

    Re: Referencing Formulas Between Worksheets

    so simple, thank you

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,718

  5. #5
    Join Date
    23rd August 2007
    Posts
    88

    Re: Referencing Formulas Between Worksheets

    How would I do that?

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,718

    Re: Referencing Formulas Between Worksheets

    Hover over the link for NAMES and follow the 1st link.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Replies: 3
    Last Post: August 22nd, 2008, 21:42
  2. Replies: 7
    Last Post: July 1st, 2008, 22:40
  3. Replies: 3
    Last Post: June 24th, 2008, 16:38
  4. Add Sheet Reference To Formula
    By mbush in forum EXCEL HELP
    Replies: 4
    Last Post: October 18th, 2007, 10:29
  5. reference sheet name in formula
    By nbsorei in forum EXCEL HELP
    Replies: 2
    Last Post: September 15th, 2005, 01:32

Bookmarks

Posting Permissions

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