Thread: Cell Offset
View Single Post
  #1   Report Post  
Jon C
 
Posts: n/a
Default Cell Offset

Hi,

Id like to be able to do an offset from a reference in another cell€¦ Help€¦..

Heres what I really mean.

A1 contains €˜January
B1 €˜February
Etc


A8 = A1, B8 = B1, etc.

Dead easy.

What Id like to do is change A8 to say C1, for March, and for the remainder
of the cells on row 8 to automatically follow in line i.e. B8=D1, etc.

Thanks,

Jon