KjBox, apologies for the delay, compare/locate Part No. and/or Description then once the correct line item has been found then if data exists in Sheet2 "NOTES" then copy data from Sheet2 "NOTES" to Sheet1 "System".
I have no idea where do go with this one and my VBA knowledge is pretty close to ZERO. I have 6000 lines of inventory and need VBA's/your help.
The summation is to compare the Description between 2 sheets (Count and Master) then copy the quantity to the matching data's line in the Master sheet.
Just a thought but if description doesn't match, can it be colored RED or can we easily search/locate matching data?
These descriptions may contain special characters.