I have scoured all the other "combine list" threads and none are quite
like this problem. I hope someone out there can help

THE SETUP:
*I have two single column lists of product codes, in separate files:
list A in file A, list B in file B. Both are excel 2003.

* List A has about 60% of all the codes i need, list B has a different
~60% of the codes i need

* between them, 100% of the information exists, but there is overlap.

* no editing of file B is allowed (its not mine to play with)


THE AIM
* I want to make list A in file A the master list, with 100% of the
info with no duplication, as neatly as possible, adding the codes that
B has that A doesn't to the bottom of list A

* List A is auto filtered, I'd like to keep it that way

* I'd prefer not to make additional columns and/or worksheets if
possible, but if this is the only way thats ok. However I'd prefer a
vba solution so i can just hit a button on the worksheet in file A to
update it.


MY BACKGROUND
*still very much learning VBA, with about 1 months practical experience

I've read parts of this newsgroup before and found it very useful, this
is the first time i've asked for help from it.

Cheers,
SK