Copy paste formulas to new sheet (absolute references)

[danhendo888]

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://1drv.ms/x/s!AvjBsEPEq12ngUDMrgxRZFuYzsgm?e=ghaRAa

[/FONT]Hi guys,

I need to copy/paste cells M1:V14 to Sheet2 but have the absolute references point to the cells from the original sheet

Is there a way to do this?

 

[Trebor76]

Hi danhendo888,

Try "anchoring" the cell references before you copy them - so A1 becomes $A$1 for example. Pressing F2 and then F4 while on the cell with the formula can do this for you.

HTH

Robert

 

[danhendo888]

My cell references are already absolute references.
So when I copy and paste them to a different sheet, it references the new sheet and not the original sheet.

Is there a way around this so that $A$1 for example, when copied from Sheet1 and pasted to Sheet2, would reference $A$1 from Sheet1 and not Sheet2?

 

[Trebor76]

You need to have the sheet name as part of formula even for the sheet it's on (which Excel excludes by default) i.e. in Sheet1 you'd have this:

=Sheet1!$A$1

 

[danhendo888]

Ah I see, okay that's a good idea.
Thank you Trebor

 

[Trebor76]

You're welcome. I'm glad we got it sorted