Determining Changes between two Inventory Lists

[la90292]

I have two different dated inventory lists.

Worksheet 1, O/H 4,622, starts on row 15, ends on row 3.095
Worksheet 2, O/H 4,611, starts on row 15, ends on row 3,089.

The header columns for each list are the same.

I need to determine which items/units have change from worksheet 1 so that I
can make adjustments to my existing inventory, worksheet 2. I would like
these particular items on a new worksheet to note the items that have sold
or have been added since beginning inventory, worksheet 1. The items are
referenced in the "Desc 1" column in both work sheets. Each item has a
vendor code, size & quantity.

Assume worksheet 1 is dated 10-18-06 and worksheet 2 is dated 10-22-06.

Worksheet 1:
Columns: C = VC (vendor code) , D = Desc 1, E= Size, F= Qty

Worksheet 2:
Columns: B = VC, C= Desc 1, D= Size, E = Qty

Worksheet 3:
This sheet will show the "items" of the sold units and/or new items that
have affected the inventory since worksheet 1 was completed, as negative or
positive #. In other words, I will
be able to determine how many units were sold or added since the time
worksheet 1 was generated.

Columns: A= VC, B = Desc 1, C = Size, D = Qty, i.e. -2

Thank you for your time and consideration.

Best regards,
victor

 

[Bernard Liengme]

Go to www.cpearson.com where Chip has lots of stuff of duplicate checking
best wishes

 

[Lori]

You could try using Data > Filter > Advanced Filter on worksheet2 and
use worksheet1 as the criteria range with the option to filter in
place. This shows all items that have stayed the same. To show those
that have changed you could select the table and then:

1. Press Ctrl+; (Select visible cells)
2. Data > Filter > Show All
3. Press Ctrl+9 (or Format > Row > Hide)

Now only the cells that have changed should be showing.
Then select the visible cells in this selection (with ctrl+; again) and
copy to the new sheet.

 

[John13]

Lori,
I am trying this too and when I hit Data>Filter>Show All, everything
returns, negating the Advanced Filter (which worked fine). Because
everything returns, Step 3 hides the entire table. What am I doing
wrong? Thank you.

John

 

[Lori]

John the point is to keep the selection from the filter by selecting
only the visible cells with ctrl+;(semicolon) while the filter is on.
Then when you choose to show all the data, the selected fields should
still be highlighted - do not change this selection. If you now hide
the selected rows with Ctrl+9 only those rows that were not filtered
should be showing.

This is a general trick you can use to invert a selection of filtered
rows i.e. to display all the rows that are not currently showing. To
unhide all rows simply select all cells and press

ctrl+shift+9 (or Format > Row > Unhide)

 

[John13]

Got it! Thanks a million. Works like a charm. Your the best.

John