|Subject:||Merge 2 Excel Worksheets|
|Posted by:||Mondou (pierretravers…@sympatico.ca)|
|Date:||6 May 2006|
I have 2 Excel worksheets that I am trying to merge but can't figure
out how to do it with Excel 2002.
File A (PriceList.xls) has the following fields:
ITEM, DESCRIPTION, COST
File B (InfoList.xls) has the following fields:
ITEM, DESCRIPTION, WEIGHT, DIMENSIONS, UPC, DISCONTINUED( Discontiued
items have an ''X'' value)
I need to merge these 2 files to form 1 single file with updated
information keeping in mind that:
- ITEM Field: Some ITEMs from file A may not be in file B and
- DESCRIPTION Field: Data from both Files may be slightly different in
which case, File B's DESCRIPTION overides File A's DESCRIPTION.
Is there a simple way to do this ?