Help with inventory data

modi

New Member
Joined
Jul 11, 2006
Messages
3
I am working with inventory data and wanted to see if someone could help me with the data. I have data that is pulled from a central database in Workbook 1 that contains serial numbers, barcodes, ect. I the same/similar data that was gathered physically of all the equipment in workbook 2. What I need to be able to do if at all possible is match the serial numbers from Workbook 1 and 2 then identify any discrepancies. What I would like if at all possible is something along the lines of 3rd Workbook that has all the serial numbers and possibly a cell or two like the barcode next to it that is color coded like:

If in Workbook 1 and 2 = Green
If in Workbook 1 not 2 = Red
If in Workbook 2 not 1 = Yellow

The reason I want the color coding is this will tell me and my team mates what is missing from the database. The database is not one we have much access or rights to, we are only able to pull data out and put data in.

Is that even possible? The current workbooks are like the following:

Workbook 1:
Is raw data pulled from a Database that has columns A – E
Column A is the Serial number and B – E are descriptions of a/the item
Workbook 1 has 276 rows

Workbook 2:
Is data pulled from the physical equipment and has columns A – E
Column A is the Serial number and B – E are descriptions of a/the item
Workbook 2 has about the same number of rows as Workbook 1, I need to roll up the numbers to verify.

Any help or point in the right direction would be most helpful, Thanks in advance!
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Watch MrExcel Video

Forum statistics

Threads
1,113,953
Messages
5,545,153
Members
410,666
Latest member
forzasec
Top