Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    North Carolina, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formula copy to another cell keeping same referenc (2000)

    Hi Loungers, I have a spreadsheet with formulas in the lower half of the spreadsheet, that I want to present in a different format on the upper half of the spreadsheet. The formulas point to another worksheet and I want to keep these references intact. For example, in cell b49, I have this formula:

    =SUM('Analysis 60,90,D'!G54:G56)/1000

    I would like b34 to point to this exact place; however, when I copy and paste special (formulas) it changes the references to other cells.

    Any way to copy this over such that it keeps the references exactly intact?

    Please advise.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Formula copy to another cell keeping same referenc (2000)

    See the very recent thread starting at <post#=458379>post 458379</post#>.

  3. #3
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    North Carolina, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula copy to another cell keeping same referenc (2000)

    Perfect. Thanks.

  4. #4
    Star Lounger
    Join Date
    Mar 2001
    Location
    Ontario, Canada
    Posts
    57
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Formula copy to another cell keeping same referenc (2000)

    Some time ago I saw a reference to ASAP utilities here in the lounge. Among lots of other nice goodies, they do have an option to copy formulas without changing their references.

Posting Permissions

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