|
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! |
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! |
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! |
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! |
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! |
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! |
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! |
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! |
copying formula for horizontal data to vertical in different s
whats does the G1 represent in your formula?
i'm trying to use this formula and my data is is array e7:e62 on sheet 1 and i need to put in a formula on a sheet 2 that starts at e20 that will give me cell e7. when i go to cell f20 on sheet2 it will grab cell e8 from sheet 1 and so on. please help! thanks!! On Aug 14, 12:05*pm, Gord Dibben <gorddibbATshawDOTca wrote: Enter this in B9 on destination sheet. =INDIRECT("Sheet1!D"&COLUMN(G1)) Copyacross 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 -verticalto 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)) Copydown as needed. -- Biff Microsoft Excel MVP "twototango" wrote in message ... I have raw data that ishorizontalin a worksheet. *I need to pull it into a report, and it needs to bevertical. *For example, data is in A1, B1, C1, D1, E1 ..... In my report sheet I enter ='Raw Data'!A1. *I then try tocopy my formulavertically 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!- Hide quoted text - - Show quoted text - |
copying formula for horizontal data to vertical in different s
Hi, please help
My data is on sheet 1 E7:E62. i need this to display horizontally on sheet 2 starting from E20:BH20. so e20 returns value e7 and f20 returns value e8. please help, thanks!! On Aug 14, 12:05*pm, Gord Dibben <gorddibbATshawDOTca wrote: Enter this in B9 on destination sheet. =INDIRECT("Sheet1!D"&COLUMN(G1)) Copyacross 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 -verticalto 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)) Copydown as needed. -- Biff Microsoft Excel MVP "twototango" wrote in message ... I have raw data that ishorizontalin a worksheet. *I need to pull it into a report, and it needs to bevertical. *For example, data is in A1, B1, C1, D1, E1 ..... In my report sheet I enter ='Raw Data'!A1. *I then try tocopy my formulavertically 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!- Hide quoted text - - Show quoted text - |
copying formula for horizontal data to vertical in different s
Enter this formula on sheet2 E20 and copy across as needed:
=INDEX(Sheet1!$E7:$E20,COLUMNS($E20:E20)) -- Biff Microsoft Excel MVP wrote in message ... whats does the G1 represent in your formula? i'm trying to use this formula and my data is is array e7:e62 on sheet 1 and i need to put in a formula on a sheet 2 that starts at e20 that will give me cell e7. when i go to cell f20 on sheet2 it will grab cell e8 from sheet 1 and so on. please help! thanks!! On Aug 14, 12:05 pm, Gord Dibben <gorddibbATshawDOTca wrote: Enter this in B9 on destination sheet. =INDIRECT("Sheet1!D"&COLUMN(G1)) Copyacross 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 -verticalto 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)) Copydown as needed. -- Biff Microsoft Excel MVP "twototango" wrote in message ... I have raw data that ishorizontalin a worksheet. I need to pull it into a report, and it needs to bevertical. For example, data is in A1, B1, C1, D1, E1 ..... In my report sheet I enter ='Raw Data'!A1. I then try tocopy my formulavertically 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!- Hide quoted text - - Show quoted text - |
| All times are GMT +1. The time now is 05:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com