I've lost my formula for merging data ?
Posted by Gavin Williams on January 16, 2001 12:59 AM
Hi,
Does anyone know the formula for the following:
Spreadsheet A has 50 product codes
Spreadsheet B has 100 product codes, but also quantities against the product codes.
As the products in A are also in B, Im looking for the formula/macro that will easily allow me to add the quantites to the correct product code in spreadsheet A.
I used to know how to do this, but I've lost the original spreadsheet I previously had it in!
Can anyone help?
Gavin