=OFFSET($B$118,0,ROW()-ROW(first_ref)) where first_ref is the absolute
reference of the cell in which you have the formula pointing to B118.
--
David Biddulph

"LEOPARDSHIDEAWAY" wrote in
message ...
I have two worksheets set up, one has data entered weekly in a row. i need
to copy this data to the other worksheets by column. my question is, i
have
the first column going to the first row in the correct places. Right now
if
i drag it down cell B118 becomes B119 in the first column, is there a way
to
make it go to C118 instead of changing the 118 to 119 when i drag it down?
I
tried using B$118 but then i still get B118 i need it to read C118. I
have
52 rows i need to drag down and do not feal like doing each one
individually.

Thanks!