how to insert a collum on a sheet without it changing cell ref
I would like to insert the collumn at the first collumn, the data I insert
has a date then other numbers below that, I need to grab the date for 1
calculation then the numbers for others. I would have a simular problem with
the date if it is not in A1
--
Thank You alot
for taking your time to reply to my post
"Russell Dawson" wrote:
I understand the problem. It only happens when you insert a column at column
A. If you insert a column to the right of A then it doesn't happen as you
know.
Is that an option?
--
Russell Dawson
Excel Student
"Just Me" wrote:
Its difficult to explain but I have this formula on a sheet:
=COUNTIF(Numbers!$A3:Numbers!AE3,1)
I want to be able to insert a collum on the Numbers sheet and put in new
data there without the cell reference $A3 changing to $B3
--
Thank You Much
for taking your time to reply to my post
|