|
transposing a column
Hi
Have a protected sheet that accepts data in col B. I would like to have this column transposed to horizontal on a HIDDEN sheet 2 as it is entered on sheet1. The idea behind this is that I can then pick up (copy) the single line from sheet2 and paste this into a single line on a separate spreadsheet. All suggestions welcome. |
transposing a column
Enter anywhere in Sheet2, and copy across as needed:
=Index(Sheet1!$B:$B,Columns($A:A)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "johnsail" wrote in message ... Hi Have a protected sheet that accepts data in col B. I would like to have this column transposed to horizontal on a HIDDEN sheet 2 as it is entered on sheet1. The idea behind this is that I can then pick up (copy) the single line from sheet2 and paste this into a single line on a separate spreadsheet. All suggestions welcome. |
transposing a column
Forgot to mention that when you copy from Sheet2, you should use "Paste
Special" <Values wherever you decide to paste the copied data. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "RagDyer" wrote in message ... Enter anywhere in Sheet2, and copy across as needed: =Index(Sheet1!$B:$B,Columns($A:A)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "johnsail" wrote in message ... Hi Have a protected sheet that accepts data in col B. I would like to have this column transposed to horizontal on a HIDDEN sheet 2 as it is entered on sheet1. The idea behind this is that I can then pick up (copy) the single line from sheet2 and paste this into a single line on a separate spreadsheet. All suggestions welcome. |
transposing a column
Hi RD
Thanks for responding - but it does not do what I would really like. To explain more. On sheet 1 data is entered in B1 down to B10. As this data is being entered I would like it to be being transposed into a single row of data automatically so that when all data fields have been filled in on sheet1 there is a row of data available on sheet 2 ready to be picked up and copied to a sheet in a second workbook. "RagDyer" wrote: Forgot to mention that when you copy from Sheet2, you should use "Paste Special" <Values wherever you decide to paste the copied data. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "RagDyer" wrote in message ... Enter anywhere in Sheet2, and copy across as needed: =Index(Sheet1!$B:$B,Columns($A:A)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "johnsail" wrote in message ... Hi Have a protected sheet that accepts data in col B. I would like to have this column transposed to horizontal on a HIDDEN sheet 2 as it is entered on sheet1. The idea behind this is that I can then pick up (copy) the single line from sheet2 and paste this into a single line on a separate spreadsheet. All suggestions welcome. |
transposing a column
Have you tried it?
That's *exactly* what my formula will accomplish! You enter the formula on Sheet2 and copy it across whatever row you wish. Now, go back to Sheet1 and enter a few values in Column B. Go to Sheet2 and you'll see them displayed there. -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "johnsail" wrote in message ... Hi RD Thanks for responding - but it does not do what I would really like. To explain more. On sheet 1 data is entered in B1 down to B10. As this data is being entered I would like it to be being transposed into a single row of data automatically so that when all data fields have been filled in on sheet1 there is a row of data available on sheet 2 ready to be picked up and copied to a sheet in a second workbook. "RagDyer" wrote: Forgot to mention that when you copy from Sheet2, you should use "Paste Special" <Values wherever you decide to paste the copied data. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "RagDyer" wrote in message ... Enter anywhere in Sheet2, and copy across as needed: =Index(Sheet1!$B:$B,Columns($A:A)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "johnsail" wrote in message ... Hi Have a protected sheet that accepts data in col B. I would like to have this column transposed to horizontal on a HIDDEN sheet 2 as it is entered on sheet1. The idea behind this is that I can then pick up (copy) the single line from sheet2 and paste this into a single line on a separate spreadsheet. All suggestions welcome. |
transposing a column
Thanks RD
Have now got it working. Your help much appreciated. "RagDyeR" wrote: Have you tried it? That's *exactly* what my formula will accomplish! You enter the formula on Sheet2 and copy it across whatever row you wish. Now, go back to Sheet1 and enter a few values in Column B. Go to Sheet2 and you'll see them displayed there. -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "johnsail" wrote in message ... Hi RD Thanks for responding - but it does not do what I would really like. To explain more. On sheet 1 data is entered in B1 down to B10. As this data is being entered I would like it to be being transposed into a single row of data automatically so that when all data fields have been filled in on sheet1 there is a row of data available on sheet 2 ready to be picked up and copied to a sheet in a second workbook. "RagDyer" wrote: Forgot to mention that when you copy from Sheet2, you should use "Paste Special" <Values wherever you decide to paste the copied data. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "RagDyer" wrote in message ... Enter anywhere in Sheet2, and copy across as needed: =Index(Sheet1!$B:$B,Columns($A:A)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "johnsail" wrote in message ... Hi Have a protected sheet that accepts data in col B. I would like to have this column transposed to horizontal on a HIDDEN sheet 2 as it is entered on sheet1. The idea behind this is that I can then pick up (copy) the single line from sheet2 and paste this into a single line on a separate spreadsheet. All suggestions welcome. |
transposing a column
You're welcome, and appreciate the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "johnsail" wrote in message ... Thanks RD Have now got it working. Your help much appreciated. "RagDyeR" wrote: Have you tried it? That's *exactly* what my formula will accomplish! You enter the formula on Sheet2 and copy it across whatever row you wish. Now, go back to Sheet1 and enter a few values in Column B. Go to Sheet2 and you'll see them displayed there. -- Regards, RD -------------------------------------------------------------------------- --------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------------- --------------------- "johnsail" wrote in message ... Hi RD Thanks for responding - but it does not do what I would really like. To explain more. On sheet 1 data is entered in B1 down to B10. As this data is being entered I would like it to be being transposed into a single row of data automatically so that when all data fields have been filled in on sheet1 there is a row of data available on sheet 2 ready to be picked up and copied to a sheet in a second workbook. "RagDyer" wrote: Forgot to mention that when you copy from Sheet2, you should use "Paste Special" <Values wherever you decide to paste the copied data. -- Regards, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "RagDyer" wrote in message ... Enter anywhere in Sheet2, and copy across as needed: =Index(Sheet1!$B:$B,Columns($A:A)) -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "johnsail" wrote in message ... Hi Have a protected sheet that accepts data in col B. I would like to have this column transposed to horizontal on a HIDDEN sheet 2 as it is entered on sheet1. The idea behind this is that I can then pick up (copy) the single line from sheet2 and paste this into a single line on a separate spreadsheet. All suggestions welcome. |
| All times are GMT +1. The time now is 02:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com