Hi, I tried the code and it is generating random item codes like 66, 2, 1 etc which are not in the item code list. It did however work for item code 999...
OK - you need to set up a lookup table somewhere in your workbook - all product codes and their prices. You can then use a VLOOKUP formula to bring the...
Knowledge Base Articles By Category
Recent Forum Posts
VBA Duplicate Value in Column And Perform Calculation
Hi, I tried the code and it is generating random item codes like 66, 2, 1 etc which are not in the item code list. It did however work for item code 999...
bluesky33 Today, 06:40 PM