1. open Excel
2. from Excel:
File Open oldsheet.xls
File Open newsheet.xls

3. select the column in the oldsheet and copy it
4. paste into the newsheet.
--
Gary''s Student - gsnu200731


"nastech" wrote:

want to use work column in main sheet to bring in a column from an old sheet.
is there a way to do this? should then be able to copy-paste values to
correct column in new sheet. thanks