Write a macro that processes the following sales data (your final code should work with data that have any number of products, different number of price breaks, different quantities for a price break, different % of extra discount, different amount for a total discount and a list with more or fewer clients). It can be safely assumed that the data in the “Products” worksheet has the word “Product” in an anchor cell (e.g., cell A4) and the “Extra Discount” and “If more than” values are two columns to the right from the last column with price breaks. Similarly, the “Total Ordered”, “Total Amount” and “Total Amount (with extra discount)” columns are after skipping one column (as shown in the example below). In the worksheet named “Products” the following example data are given:
#Sales Offer!| Get upto 25% Off: