[VBA] Macro to apply discount to Order Form

Thanks for the reply.

Not really. Cell C17 would ideally be the same as the value entered in C18 after the computation is done.

When a value is entered in cell C18, all discount values in column F are rendered irrelevant( ie. " ") . Only the new value in cell C18 should apply. In its application, the value in cell C18 should apply to column H (Total without discount).

If I enter 10% in cell C18 and the total is 10,000 (discounted value is then 1,000).

I want this 1,000 to be subtracted first from the of Product Offering C and then on Product Offering B... until the 1,000 is exhuasted.

Sorry for my miscommunication.

I don't want the new value in cell C18 to reflect on each item on the rows. I would like to value in C18 to apply to total value of the order, where the discount amount is first applied to total value of Product Offering C -A.

This will then happen when a value is enter in C18:¨

1. All value in column F are deleted
2. Take discount on total in C16 using value in C18
3. The discount amount is spread over the total of Product Offerings C-A in column I

1) Column F is meant to be a hard code for a sales rep to enter a discount so that cannot change
2)I don't want the value in C18 to apply to all items under column C. I want it to only apply to total and thereafter, the discounted amount spread over values in column I

Is there a way to do this in VBA?

!UPDATE!

I need help in creating a macro such that, when a discount value is entered in C18 and the button is clicked:

1. the values in column F will be deleted
2. the discount percentage in C18 will be applied to the value in C16
3. this discounted amount will be spread over the totals of Product Offering C to A in column I

4. meaning that if the value in C16 is 10,000 and 50% is entered in C18, and the total of Product Offering C - A are 2000, 3000 and 5,000 respectively (the sum is then the value in C16 =10,000).
5. the discount value will be 5,000
6. 2000 of the discounted value (5,000) will be applied to first to Product Offering C. (meaning the sum of Product Offering C will 100% discount)
7. the remaining 3000 of the discount value will then be applied to Product Offering B. (again, meaning a 100% discount it)
8. it should always follow this order: Product Offering C --> Product Offering B ---Product Offering A


I hope the explanation of the problem is quite clear.

I would appreciate any help with this. Thank you.

Hi guys, I managed to figure it out. Thanks for your help.