Is there a way to get a column of numbers from one sheet to another, where
rows have changed order. I have compared sheets before to the same column,
but need the data. examples 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",""))

Note: col AA is a unique symbol, looking for numbers in column DD, that
line up with the same symbol, starting at line 99.
Main sheet keeping: symbols.xls
Backup: xsymbols.xls
(if have the exclamation point "!" correct, etc... thanks