Mondou
VBA is the only way you're going to be able to do this. You didn't say
how you want the columns arranged in the final product. Since B has more
columns than A, I would copy the A data to the B data rather than vice
versa. So where does the COST column go in the B data?
Also you start off by saying you have 2 worksheets. But later you say
you have "File A" and "File B". What do you have, two sheets in one file or
two files? If you have 2 files, how many sheets of pertinent data do you
have in each file? Post back with the answers and I'll work up something
for you. HTH Otto
"Mondou" wrote in message
oups.com...
Thanks for your response.

Problem is, there are alot of duplicates... about 900. I am trying to
join 2 files into 1 Masterfile that contains different information for
the same item numbers. There are only a few new items.

I am getting these new files on a regular basis so I need a way to
merge them together regularly.

I've heard of the following ways:

Mail Merge (don't think that this is useful since I need to have them
in Excel not Word).

Microsoft Query (Can't figure out how to use it)

VCOUNT: ( ???)

VBA : Newbie, but willing to try if this is the only option

Which one of these option is best and how could I do this ?

Thanks