updating one cell changes another or vice versa

[mattybaz]

I'm doing a quick discount % and discount price calculator.

Let's say that row a,b,and c contain a list price, discount %, and discount price respectively. I want to be able to change either the discount % and it will recalculate the discount price or change the discount price and it will recalculate the discount %. So to put it more clearly:

cells in row A: Contain the List (undiscounted) price. This will never change.

cells in row B: Will be a discount %. It is equal to:
(list price - discounted price)/list price. needs to be recalculated if discounted price changes. Also, it should only contain data if the cell in Row A - list price - contains data.

All cells in row C: Will be a discount price. It is equal to:
(1-discount %)*list price. needs to be recalculated if discount % changes. Also, it should only contain data if the cell in Row A - list price - contains data.

Thanks for your help!

 

[lenze]

nevermind the column a = 0 comment. That's not right. However, I did figure out how to move everything with your help. Thanks! Any ideas on the column headings or only starting this on line 11?

To start at line 11, simply add the line.

If Target.Row < 11 Then Exit Sub

Search the help files as time allows for the properties of the various objects in VBA.

lenze

 

[mattybaz]

Thanks for all the help! This will be perfect!