QTY 100 PRICE $5.00 TOTAL $500.00
So I have a worksheet where the inputs are QTY and PRICE, and the TOTAL being the formula QTY * PRICE..
I would like to be able to input a value into the TOTAL cell and have it change the PRICE cell's .value by dividing the value entered by the QTY, then reverting back to its original formula..
I've been experimenting with worksheet change but i'm too out of practice with vba lately..
any help is much appreciated