Hilight the row, copy, then select the first cell in a blank column, right
click, paste spectial, and check the Transpose box at the bottom
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"LEOPARDSHIDEAWAY" wrote:

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!