transposing a column

J

johnsail

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

RagDyer

Enter anywhere in Sheet2, and copy across as needed:

=Index(Sheet1!$B:$B,Columns($A:A))
 
R

RagDyer

Forgot to mention that when you copy from Sheet2, you should use "Paste
Special" <Values> wherever you decide to paste the copied data.
 
J

johnsail

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

RagDyeR

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

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.
 

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

Transposing hundreds of addresses in a column using VBA 7
move blank data 10
Same Column on Two Sheets (Auto-update / match)? 4
retrive data from oher sheet on a condition 7
transposing vertical data to horizontal with varying amount of data 5
alter code to apply to range (links cells w/ row insertions) 1
Transposing Large Number of Names 1
Auto Fill formula from a column to row 1

Top