View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Barnej75 Barnej75 is offline
external usenet poster
 
Posts: 4
Default Relative Reference help

I am trying to create a macro that will take values that change and
paste them one line below where the previous days numbers where
pasted. So if A1 is a ten I need it to paste in A2. Then the next
day A1 may be a 15 and I need it to paste in A3. I have tried many
things and it always copies the cell above instead of A1. Thanks in
advance.