Formula copy to another cell keeping same referenc (2000)

Topic

New Reply

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.

Reply | Quote

Replies

See the very recent thread starting at post 458379.

Reply | Quote

Perfect. Thanks.

Reply | Quote

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.

Reply | Quote