Compare 2 files and Update

I am trying to compare and update 2 Excel files.

Both files have the same information, product ID number and quantity.
I want to compare file 1 (master) with file 2 (updated). I want to
verify that the product ID numbers are the same, if so, then update the
quantity with the newer number.

Column A Column B
-------------------------------------
Product ID Quantity

12345 25

*Product ID & Quantity are headers, columns A & B are just for
reference.


I would like generate a new updated file in the original format

Thanks for any suggestions.
Harold

use the vlookup formula. See Excel help on Vlookup.

--
Regards,
Tom Ogilvy


"Suncoast" <[email protected]> wrote in message
news:[email protected]...
> I am trying to compare and update 2 Excel files.
>
> Both files have the same information, product ID number and quantity.
> I want to compare file 1 (master) with file 2 (updated). I want to
> verify that the product ID numbers are the same, if so, then update the
> quantity with the newer number.
>
> Column A Column B
> -------------------------------------
> Product ID Quantity
>
> 12345 25
>
> *Product ID & Quantity are headers, columns A & B are just for
> reference.
>
>
> I would like generate a new updated file in the original format
>
> Thanks for any suggestions.
> Harold
>