Help with Inventory-Job on the line Folks
I have a spreadsheet that has two worksheets...One has the physical counts taken at a store...The other worksheets is the master item table that contains the pricing, UPC's and other various information. I must match the Physical Worksheet UPC on one column in the Master Item Table as an exact match, or, match it to another column in the Master Table less the last digit in the Physical Worksheet UPC column. I have been working on this for two weeks and just can't figure it out. Can anyone help me with this? I have tried Crystal Reports, doing joins, etc. but I always keep coming back to Excel...I would be very grateful for any help...I wished I could attach the spreadsheet, but can't....Any help out there?