Merging two excel files? Macro/Merge?

[adamrace]

Hi,

I've got two excel files, one has a list of products and their current prices and they all have a product ID, I have another file with a list of price's that need updating. I was wondering what the best way of going about merging the two files together, with the old price and the new price using the ID's. The second file has a list of all the products on their system, the first has just a few of these which are on the other system. If anyone has any ideas of how to either write a macro or use scenario>merge? The problem i was having with the merge is that you can only have 32 cells at a go.

Cheers for any help.

Adam

 

[SkipVought]

Hi,

Assuming that your workbooks have sheets that contain tables, you could easily QUERY and JOIN the tables as appropriate to return whatever subset of data you choose.

Probably no VBA required.

faq68-5829

Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FOURTH[/red] on the [red]FIFTH[/red]}