Hi
you need top provide some more information HOW your files look like:
- e.g post some sample data
- describe the expected result,
- etc.

--
Regards
Frank Kabel
Frankfurt, Germany

"John F" <John schrieb im Newsbeitrag
...
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!!!