Data / Pivot Table / Multiple Consolidation Ranges
--
Gator


"Gameware" wrote:


Spread sheet 1 shows entire inventory data base and includes:

Item Description # column (ie 0001)
Item Description column (ie Widget)
Quantity on-hand column (ie 12)

Spread sheet 2 shows only inventory items that have selling activity.

Item Description # column (0001)
Item Description column (Widget)
Quantity sold column. (6)

How can I combine these two spreadsheets so I can get the following data?:

Item # Description Qty on hand Qty sold
0001 Widget 12 6

Spreadsheet 1 shows all 10,000 inventory items while spreadsheet 2 shows
only those inventory items that have sold. (Only a small fraction of the
10,000 inventory items.) What I really need is a final spreadsheet that
shows only inventory items that have sold that includes the information
above. Thanks.