how to copy data from one sheet to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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 are:

=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
 
Back
Top