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
Maybe :
Please Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
Hi there,
Try the Worksheet_Change event macro where I've assumed the following cell references (change to suit): QTY = B2, PRICE = B3 and TOTAL = B4
Regards,Please Login or Register to view this content.
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Thank you @karedog and @Trebor76! Both of your suggestions work great! I appreciate your time to help me!
Thanks!
You're welcome. Thanks also for marking the thread as solved and for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks