I'm working on a sheet that shows various discounts for products based on how much volume of product is purchased. I have a data validation box that lists the various amounts required (1 case, 2 case, etc.), and I have a sheet that has all the data (A1 is empty - column A is the case quantity - column B has a product name in B1 and then each discount based on the case quantity in Column A). I want the discount amount in Sheet 2 to fill in automatically based on the information on Sheet 1. Thanks for any help you can give me!
Bookmarks