Linking Data from Rows to Columns

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!
 
J

JP

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
 
B

Bernie Deitrick

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
 
T

Tyro

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
 
J

jeffmp21

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...
 
G

Gord Dibben

What I want to know is how you get "several hundred columns" using Excel 2000?


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulas in a column 3
Fill a Combobox from a ROW? 4
Need help deleting data 2
Excel 2007- Adding data in multiple cells at the same time 1
Display index of column headers in column A 9
Linking data from one worksheet to other worksheets using a formul 4
How to transpose data (Row to column) without losing the cell link 3
convert column to row 2

Top