How to display stocktake results.

[chriscmartin]

Please see attached file.

In the file I have 2 tables of data, input from the scan gun (A5: up to E2000) and stock file data (H5: up to M2000)

I have the formulas to compare the ids from both lists and report whether there is a match or a blank call (displayed as end of data) which I ignore and if there is a id not in both lists it shows the ID.

What I need is a way to display this info nicely, preferably showing matching data from the tables.

Any ideas?

File attached here Stock Take.xls

[aydeegee]

Hi chriscmartin

Interesting.... most stocktakes that I have conducted/attended count the items of stock. I note that you do not bother with such trvialities!

You will note that I have chosen to pick up the location and the "time" (I guess that this is another Welsh convention). You can always filter to exclude "Not scanned"

Let me know if I have completely misunderstood your requirements.

Regards
Alastair