Hi, newbie in VBA here so would appreciate any help.
Essentially this is a simple inventory management sheet in which i want to check if i have sufficient quantity of a particular product in inventory to sell to a customer.
I need help with a macro to find in "Inventory" sheet, B17, in "Data" sheet Column B from row 11 onwards and if a match is found, compare the number in "Inventory" sheet, D17, with "Data" sheet, in column D but in the row in which the first match was identified.
If the "Inventory" sheet, D17, is more than the corresponding "Data" sheet cell in column D, then a MsgBox appears.
If the "Inventory" sheet, D17, is equal to or less than the corresponding "Data" sheet cell in column D, then a different MsgBox appears.
If the the first match can't be found in row 11, then it would move on to the next row and so on.
Sorry for the long question and messy upload.
Many thanks in advance!
Bookmarks