Linking Data from Rows to Columns

  • Thread starter Thread starter jeffmp21
  • Start date Start date
J

jeffmp21

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!
 
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
 
Jeff,

In Classreport, cell C3, enter the formula

=OFFSET('Budget Entry'!$B$39,0,ROW()-3)

and copy down for as many rows as you need.

HTH,
Bernie
MS Excel MVP
 
Enter this in C3 and drag down until the number in the ROW function equals
the number of columns you have: =OFFSET($B$39,0,ROW(1:1)-1)

Tyro
 
Thank you it works great!

Bernie Deitrick said:
Jeff,

In Classreport, cell C3, enter the formula

=OFFSET('Budget Entry'!$B$39,0,ROW()-3)

and copy down for as many rows as you need.

HTH,
Bernie
MS Excel MVP
Click to expand...
 
What I want to know is how you get "several hundred columns" using Excel 2000?


Gord Dibben MS Excel MVP
 
Back
Top