cwhite86
02-26-2016, 11:20 AM
I am developing an inventory tool that checks our manually entered data for our physical inventory checks against the computer inventory list of what we should have in inventory.
So far it is working well, but I need to up the accuracy. I have attached a desensitized sample Workbook.
Sheets names etc. will be different, and product name spacing etc.
So my current hurdle is this.
Module 2 is currently looking on the 2 Physical INV pages (BI2c and BW2C) for matches.
Column C defaults everything Red, then fills anything found yellow.
But this only matches the reference number.
I need to be able to match each reference number with the cell to the left of it.
So Sheet INV Master is looking in its own Column C for matching values in (all sheets, but lets be specific for a moment) Sheet BI2C in Range B5:B15. So INV Master C2 is found, but I want to know if B2 matches the column the value in C2 is found. The match for B2 is found on BI2C B$3.
Right now if the value in C2 is found under a different category it still lists as found because I am searching the whole range.
Not sure if I can use a find with an and as an added restriction or is there is a better way to do this.
Anyone got any ideas? Or understand my rant?
So far it is working well, but I need to up the accuracy. I have attached a desensitized sample Workbook.
Sheets names etc. will be different, and product name spacing etc.
So my current hurdle is this.
Module 2 is currently looking on the 2 Physical INV pages (BI2c and BW2C) for matches.
Column C defaults everything Red, then fills anything found yellow.
But this only matches the reference number.
I need to be able to match each reference number with the cell to the left of it.
So Sheet INV Master is looking in its own Column C for matching values in (all sheets, but lets be specific for a moment) Sheet BI2C in Range B5:B15. So INV Master C2 is found, but I want to know if B2 matches the column the value in C2 is found. The match for B2 is found on BI2C B$3.
Right now if the value in C2 is found under a different category it still lists as found because I am searching the whole range.
Not sure if I can use a find with an and as an added restriction or is there is a better way to do this.
Anyone got any ideas? Or understand my rant?