Linking Data from Rows to Columns
Highlight the cells, right-click and choose "Copy", select the Classreport
sheet, cell C3, rightclick and choose "Paste Special", select the "Transpose"
button. This should do what you want.
HTH,
JP
"jeffmp21" wrote:
In the first sheet titled "Budget Entry" I have data that starts in row b39
and continues out for several hundred columns. I need this data in a second
sheet titled Classreport starting in cell C3 and proceeding down the column
for a corresponding number of rows. Obviously I could use "=" but this
would take a considerable amount of time. Unfortunately we are still using
excel 2000. Is this possible? Thank you!
|