Hi Guys,
Probabilly really simple,
I have referenced data in two colums on a sheet A and B,
Column A contains the latest data, each month i insert new column (moving column A to column B)
However all of my references continue to follow the original data (eg will change from column A to column B)
this happens despite using Absolute references. (=$A$1)
Is there a way to lock these cell references to only ever display column A etc?
Bookmarks