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.