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

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

hi, thanks for the response. have a problem where rows are moved around.
have a worker column can use in new sheet, need a formula to pull data in
that lines up with same name in "name" column, from both sheets. rough
examples, for comparing data.. have a

=IF(OR(COUNTIF($AA$1:$AA$3000,AA99)=1,AA99={"","." ),"",COUNTIF($AA$1:$AA$3000,AA99))

=IF(OR(AA99={"","."}),"",IF(ISNA(VLOOKUP(AA99,[xsymbols.xls]symbols!$AA$1:$AA$3000,1,0)),"dif",""))

NOT Sure how to setup what I need. thanks

"Gary''s Student" wrote:

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