Power Query
June 25, 2016
Hello -
This may be beyond my current capabilities, but I have multiple 'calculators' set up on separate worksheets to perform a basic calculation done on a user entered value. Instead of having the user select each worksheet tab for each individual product, I would like for them to be able to select the product from a drop down, then enter a value and have the calculation done on that entry and return a result. I would like for this to be on just one worksheet or via a basic user interface.
Would this require VBA to accomplish? I have a basic to intermediate skill level within Excel.
Any thoughts on the simplest method to accomplish this would be very helpful.
Thank you,
Dave
VIP
Trusted Members
June 25, 2016
Hi Dave
Without looking at your calculators it is a bit difficult to guess what you need. Depending on the complexity, you may not need any VBA (and most don't). You can create your drop-down via Data Validation and then link the selection to the calculators.
If you can share your calculators with us, it would be easier to assist.
Sunny
Power Query
June 25, 2016
SunnyKow said
Hi DaveWithout looking at your calculators it is a bit difficult to guess what you need. Depending on the complexity, you may not need any VBA (and most don't). You can create your drop-down via Data Validation and then link the selection to the calculators.
If you can share your calculators with us, it would be easier to assist.
Sunny
Thanks for the input Sunny. I've attached an example of one of the calculators mentioned. I have 12 or 13 other ones and the list will expand. As I mentioned, each is on a different worksheet currently. The format of these calculators is not critical, I only need a field for a user entered value, and a field for the calculated result. In these examples, the user enters the value in the box, and the result displays in red.
VIP
Trusted Members
June 25, 2016
VIP
Trusted Members
June 25, 2016
Hi Dave
The apostrophe is required in your case as the worksheet name referred to consist of more than one word.
The normal formula would look like this ='Calculator A'!A1
I need to join the apostrophes to the sheet's name so I need to put them in double quotes before joining.
If your sheet's name consist of only one word, then the apostrophe is not required e.g. =CalculatorA!A1
Hope this is clear to you.
Sunny
Answers Post
1 Guest(s)