| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying formula for horizontal data to vertical in different sheet
I have raw data that is horizontal in a worksheet. I need to pull it into a
report, and it needs to be vertical. For example, data is in A1, B1, C1, D1, E1 ..... In my report sheet I enter ='Raw Data'!A1. I then try to copy my formula vertically but it copies vertically from my data sheet. When I make the row absolute by adding $ it still copies vertically even though I leave the column as relative. I have a lot of data and it takes too long to do one at a time. Any help would be appreciated. Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copying formula for horizontal data to vertical in different sheet
have you tried to copy and paste special transpose?
hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "twototango" escreveu: I have raw data that is horizontal in a worksheet. I need to pull it into a report, and it needs to be vertical. For example, data is in A1, B1, C1, D1, E1 ..... In my report sheet I enter ='Raw Data'!A1. I then try to copy my formula vertically but it copies vertically from my data sheet. When I make the row absolute by adding $ it still copies vertically even though I leave the column as relative. I have a lot of data and it takes too long to do one at a time. Any help would be appreciated. Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copying formula for horizontal data to vertical in different s
Hi,
Yes, I tried that but it doesn't work. "Marcelo" wrote: have you tried to copy and paste special transpose? hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "twototango" escreveu: I have raw data that is horizontal in a worksheet. I need to pull it into a report, and it needs to be vertical. For example, data is in A1, B1, C1, D1, E1 ..... In my report sheet I enter ='Raw Data'!A1. I then try to copy my formula vertically but it copies vertically from my data sheet. When I make the row absolute by adding $ it still copies vertically even though I leave the column as relative. I have a lot of data and it takes too long to do one at a time. Any help would be appreciated. Thanks! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copying formula for horizontal data to vertical in different sheet
Try this:
Assume you're wanting the data to start in cell A1: =INDEX('Raw Data'!A$1:E$1,ROWS(A$1:A1)) Copy down as needed. -- Biff Microsoft Excel MVP "twototango" wrote in message ... I have raw data that is horizontal in a worksheet. I need to pull it into a report, and it needs to be vertical. For example, data is in A1, B1, C1, D1, E1 ..... In my report sheet I enter ='Raw Data'!A1. I then try to copy my formula vertically but it copies vertically from my data sheet. When I make the row absolute by adding $ it still copies vertically even though I leave the column as relative. I have a lot of data and it takes too long to do one at a time. Any help would be appreciated. Thanks! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copying formula for horizontal data to vertical in different s
Biff:
That is soooo excellent!! You have saved me countless hours. You are truly an MVP!!! I will love you forever!!!!!!!!!!!!! "T. Valko" wrote: Try this: Assume you're wanting the data to start in cell A1: =INDEX('Raw Data'!A$1:E$1,ROWS(A$1:A1)) Copy down as needed. -- Biff Microsoft Excel MVP "twototango" wrote in message ... I have raw data that is horizontal in a worksheet. I need to pull it into a report, and it needs to be vertical. For example, data is in A1, B1, C1, D1, E1 ..... In my report sheet I enter ='Raw Data'!A1. I then try to copy my formula vertically but it copies vertically from my data sheet. When I make the row absolute by adding $ it still copies vertically even though I leave the column as relative. I have a lot of data and it takes too long to do one at a time. Any help would be appreciated. Thanks! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copying formula for horizontal data to vertical in different s
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "twototango" wrote in message ... Biff: That is soooo excellent!! You have saved me countless hours. You are truly an MVP!!! I will love you forever!!!!!!!!!!!!! "T. Valko" wrote: Try this: Assume you're wanting the data to start in cell A1: =INDEX('Raw Data'!A$1:E$1,ROWS(A$1:A1)) Copy down as needed. -- Biff Microsoft Excel MVP "twototango" wrote in message ... I have raw data that is horizontal in a worksheet. I need to pull it into a report, and it needs to be vertical. For example, data is in A1, B1, C1, D1, E1 ..... In my report sheet I enter ='Raw Data'!A1. I then try to copy my formula vertically but it copies vertically from my data sheet. When I make the row absolute by adding $ it still copies vertically even though I leave the column as relative. I have a lot of data and it takes too long to do one at a time. Any help would be appreciated. Thanks! |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copying formula for horizontal data to vertical in different s
This is great but i can't get it to work the other way - vertical to
horizontal - Help!! My Data runs from D7 to D230 vertically on one sheet and i want it to display in another sheet from B9 to TT9(or there abouts!) Regards "T. Valko" wrote: You're welcome. Thanks for the feedback! -- Biff Microsoft Excel MVP "twototango" wrote in message ... Biff: That is soooo excellent!! You have saved me countless hours. You are truly an MVP!!! I will love you forever!!!!!!!!!!!!! "T. Valko" wrote: Try this: Assume you're wanting the data to start in cell A1: =INDEX('Raw Data'!A$1:E$1,ROWS(A$1:A1)) Copy down as needed. -- Biff Microsoft Excel MVP "twototango" wrote in message ... I have raw data that is horizontal in a worksheet. I need to pull it into a report, and it needs to be vertical. For example, data is in A1, B1, C1, D1, E1 ..... In my report sheet I enter ='Raw Data'!A1. I then try to copy my formula vertically but it copies vertically from my data sheet. When I make the row absolute by adding $ it still copies vertically even though I leave the column as relative. I have a lot of data and it takes too long to do one at a time. Any help would be appreciated. Thanks! |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copying formula for horizontal data to vertical in different s
Enter this in B9 on destination sheet.
=INDIRECT("Sheet1!D"&COLUMN(G1)) Copy across to TT9 or thereabouts. Gord Dibben MS Excel MVP On Thu, 14 Aug 2008 09:21:01 -0700, Jonathan wrote: This is great but i can't get it to work the other way - vertical to horizontal - Help!! My Data runs from D7 to D230 vertically on one sheet and i want it to display in another sheet from B9 to TT9(or there abouts!) Regards "T. Valko" wrote: You're welcome. Thanks for the feedback! -- Biff Microsoft Excel MVP "twototango" wrote in message ... Biff: That is soooo excellent!! You have saved me countless hours. You are truly an MVP!!! I will love you forever!!!!!!!!!!!!! "T. Valko" wrote: Try this: Assume you're wanting the data to start in cell A1: =INDEX('Raw Data'!A$1:E$1,ROWS(A$1:A1)) Copy down as needed. -- Biff Microsoft Excel MVP "twototango" wrote in message ... I have raw data that is horizontal in a worksheet. I need to pull it into a report, and it needs to be vertical. For example, data is in A1, B1, C1, D1, E1 ..... In my report sheet I enter ='Raw Data'!A1. I then try to copy my formula vertically but it copies vertically from my data sheet. When I make the row absolute by adding $ it still copies vertically even though I leave the column as relative. I have a lot of data and it takes too long to do one at a time. Any help would be appreciated. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| moving data from vertical to horizontal possition | Excel Worksheet Functions | |||
| Need lookup of data both vertical and horizontal | Excel Discussion (Misc queries) | |||
| how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions | |||
| How to make Horizontal data go Vertical | Excel Worksheet Functions | |||
| tranfere vertical data to horizontal tabel | Excel Worksheet Functions | |||
Hybrid Mode
