Cell references

[WadeWatts]

Hi all,
I think a simple one for most of you.

I know if i put $ in a formula for cell reference, and how that works.
is there a way of doing the opposite?

i mean if cell A1 is looking at C1, but i then move column C's data out to column D, can i have A1 keep looking at whatever now falls into C1, rather than follow it to D1.

many thanks
WoW

 

[WadeWatts]

Is this what you want? Check and revert...

YOU DID IT

thank you.
I knew there had to be a way but being unaware of the formulas, i didnt know how to get my ask across properly.

that covers it all, thanks for the assistance

 

[SanjayGMusafir]

YOU DID IT

thank you.
I knew there had to be a way but being unaware of the formulas, i didnt know how to get my ask across properly.

that covers it all, thanks for the assistance

Glad we could help you. We all learn as we need to improvise...