Announcement

Collapse
No announcement yet.

Copy Formula To Different Worksheet & Reference That Sheet

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    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.

    Comment


    • #3
      Re: Referencing Formulas Between Worksheets

      so simple, thank you

      Comment


      • #4
        Re: Referencing Formulas Between Worksheets

        You can copy if you use Sheet Level Named Ranges.

        Comment


        • #5
          Re: Referencing Formulas Between Worksheets

          How would I do that?

          Comment


          • #6
            Re: Referencing Formulas Between Worksheets

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

            Comment

            Working...
            X