On the sheet you want your column. Initially create a row that links
straight back to the source data, but don't have this row cross the column
you want to put your data in. So what you have now is simply a row that
equals the other row. Select the range, edit / replace, replace = with %%.
Copy range, paste special / transpose to where you want your column, select
data in column, edit / replace, replace %% with =.

Delete the helper range.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Dennis Harrelson" wrote in message
...
Hello, Folks
I need to have a column of values on one sheet equal a row of values on a
different sheet. i.e.: 'sheet2'A1='sheet1'A1; 'sheet2'A2='sheet1'B1;
'sheet2'A3='sheet1'C1; etc. Is there a way to do this using edit/fill or
copy? It's way too tedious to type every cell in, or even to click from
one
sheet to the other for every cell, but I can't find any short cut.
TIA,
Dennis