Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Data from Rows to Columns
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Data from Rows to Columns
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 "jeffmp21" wrote in message ... 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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Data from Rows to Columns
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 "jeffmp21" wrote in message ... 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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Data from Rows to Columns
Thank you it works great!
"Bernie Deitrick" wrote: 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 "jeffmp21" wrote in message ... 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! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Data from Rows to Columns
What I want to know is how you get "several hundred columns" using Excel 2000?
Gord Dibben MS Excel MVP On Fri, 29 Feb 2008 11:45:03 -0800, jeffmp21 wrote: Thank you it works great! "Bernie Deitrick" wrote: 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 "jeffmp21" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking 2 columns of data | Excel Discussion (Misc queries) | |||
Linking data from Rows to columns in seperate worksheets | Excel Worksheet Functions | |||
Arrange data spanning 8 columns and 3 rows to 24 columns and 1 row | Excel Discussion (Misc queries) | |||
Linking data between columns in an automatic way with dynamic link | Excel Discussion (Misc queries) | |||
Linking rows of data to another worksheet | Excel Discussion (Misc queries) |