Excel 97 - i need to merge 2 fairly large workbooks, however i cannot use
"compare and merge" because my workbooks are not direct copies of each other.
There may be a formula to do this, but I'm not sure. Please help!!!