Patrick O'Dea
asked on
Using a dropdown to choose a group of account for totalling
Hi,
This might stretch the power of excel.
The 1-minute video explains my requirement.
http://screencast.com/t/k32zhfRPzN
Note that I cannot hard code the solution. It must be flexible.
Preferably , no VBA.
Thanks!
EE-Map1.xlsx
This might stretch the power of excel.
The 1-minute video explains my requirement.
http://screencast.com/t/k32zhfRPzN
Note that I cannot hard code the solution. It must be flexible.
Preferably , no VBA.
Thanks!
EE-Map1.xlsx
Is a macro solution acceptable?
ASKER
Martin,
My preference would be no macro - but I would happily except one.
Hopefully my video is clear.
Regards,
Padraig
My preference would be no macro - but I would happily except one.
Hopefully my video is clear.
Regards,
Padraig
It is, but I do have some questions.
You say that there could be more then just "Wages" and "Rent" in the dropdown. where will the user parameters for the others be?
You also say that columns A to D are fixed data out of your control. How does it get there and what if anything in it might change?
ASKER
Martin,
Good questions.
Perhaps , at this point, we will just keep the macro simple.
Let's not worry about making it flexible. I might learn enough from the code in the macro.
THanks,
Good questions.
Perhaps , at this point, we will just keep the macro simple.
Let's not worry about making it flexible. I might learn enough from the code in the macro.
THanks,
OK be back soon.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Martin,
I am unsure what I should do with the sheet you provided.
Is there a macro I should run??
THanks again for your help.
Padraig
I am unsure what I should do with the sheet you provided.
Is there a macro I should run??
THanks again for your help.
Padraig
No, just select a value in K2.
ASKER
Thanks folks,
two excellent solutions.
I will now study the logic provided. (THis could be interesting!)
Thanks again.
two excellent solutions.
I will now study the logic provided. (THis could be interesting!)
Thanks again.
My code contains some comments that I hope explain what's going on. The macro is triggered by a change in cell K2 (see the worksheet_change event). I'll be happy to answer any questions you might have. In any case you're welcome and I'm glad I was able to help.
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014
ASKER
Thanks Marty,
Much appreciated.
I am studying the code now. (All very neat!).
I think I understand it all.
Thanks for being so helpful.
Much appreciated.
I am studying the code now. (All very neat!).
I think I understand it all.
Thanks for being so helpful.