View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
just me just me is offline
external usenet poster
 
Posts: 7
Default how to insert a collum on a sheet without it changing cell referen

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