I have a workbook I'm working on for our IT inventory.
I need it to look for the value of ItemName. If it finds it, move one cell to the right and add the value entered by the user to the existing value in that cell.
If it doesn't find an equal value for ItemName, I need it to find the first empty cell in column A, then input all 3 values entered by the user:
ItemName
Qty
Location
I can't get it to go past looking for a duplicate ItemName.
Link to download the file:
Here
Please Login or Register to view this content.
Bookmarks