Merge 2 Excel Worksheets

Giganews Newsgroups
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
vice-versa.

- 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 ?

thanks

Replies