Hello,
I am trying to create a data box that will increase or decrease my data "volume" by a percentage! I have attached a sample document.
I want to accomplish the following:
- When I type a percentage in the box the volume cells change by that percentage
Cells cannot at the same time contain a manually entered value and a formula, so I don't believe this is something you can do easily, if at all, using formulae. Shall I move your thread to the VBA section?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Yes, that would be great thank you!
All done.
The code to do this could be,
if you wanted a worksheet change event then this code would go into the worksheet module.
Please Login or Register to view this content.
So when you change E2 the code will kick in.
How you enter the percentage could be a factorPlease Login or Register to view this content.
Last edited by davesexcel; 07-27-2017 at 10:53 AM.
No code, Dave ...
EDIT: Code added by Dave.
Last edited by AliGW; 07-28-2017 at 09:03 AM.
Is there anyway to do it without code??
This issue is still not resolved! Is there something else that I need to do to get someone to look at it?
Refer to post#2 in this thread
No. As Dave has said, refer to my first response in this thread.Originally Posted by Balzer13
You have been given a working solution - have you tried it?
Yes, I have tried and am still not achieving the result I am trying to reach
If the result you are trying to reach is a formula only solution, then you aren't going to reach it.
why not place your data in a column and hide it then place the formula in the column where the data is now ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks