Need Macro to calculate cost when user select an option

[HarryC]

Hello
I want to build a template where i have various options in tiles that a user can pick and then chose categories underneath the particular option which will have a cost set and then picking various categories will calculate cost.
In a perfect example just how we chose our tv packages.

So, for example -
I have a one of the master category called "Resilience" . there will be various other master categories.
if user clicks on "resilience", underneath it, it gives various options to chose. Example SPOF, 2 DC Manual, 2 DC Auto. I want user to see the definiton of each
And then allow user to pick any of the above. (behind these there are cost for example SPOF - $100, 2 DC Manual - $200, 2 DC Auto - $300)
and if the user select any of the option, there is a sum total at the bottom which is calculating the cost.

Hope i have managed to explain what i would like excel to do and hope it is simple

Thanks again
Harry

[HarryC]

Any one please

[HarryC]

please i will very much appreciate it if anyone can help me.
my brain is now tired as been finding ways to create a template.

Thanking you all in advance.

[philaugust2004]

Can you post an example spreadsheet of desired output?

[HarryC]

I havent got any example as this is something which i am building from scratch
See attached as an example of what i am trying to achieve.. This might be impossible.

[HarryC]

Is this something really impossible? Happy to have suggestions.

[skyping]

hi harry,

here is something that should help you. remember to activate macros!!

skyping

[protonLeah]

title updated....

[protonLeah]

skyping,
Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification.

All participants:
Please do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc. Thanks.

[6StringJazzer]

hi harry,

amended version for you!

skyping

As a member for over 8 years I'm sure you are familiar with our rules and protocol. Do not post when a rule violation is noted and says not to post. The title has still not been corrected.

[HarryC]

hi i have now changed the title and hope it now complies with the rule.

[HarryC]

skyping
You posted an example spreadsheet which unfortunately was deleted due to my topic under moderation.
Hope my change in title has now satisfied and complied with forum rules.
Could you or anyone please help me out here.

MODERATOR: are you able to post the amended spreadsheet back which was posted by skyping so that i can look.


and i apologize for not complying with the rules.

[skyping]

After being unable to communicate with the appropriate moderators etc, I submit my response below:

Thank you for your communication.

If helping someone out inflicts a warning, then please escalate this to the highest authority of this forum, as it was my understanding that helping people was the main point of this and any other forum.

As I clearly understood what the OP wanted, I suggested a fix for them, which I tested and spent time on prior to your action requesting the OP to fix his title which they have now done.

After copying his requirements to a dummy workbook, I noticed an error and so amended my original workbook, and reposted, as clearly the OP needed a solution and nobody had yet replied to his request.

In future, I will refrain from helping people (as others have helped me during my 8 years in this forum) until I am 100% certain that ALL rules have been fully followed to the letter.

In the meantime, I will repost my solution once I return to my home (the workbook is ONLY on my home PC), which will be much later today, as I understand that the OP needs a solution and I was the only person willing to spend time and effort to help them.

Regards,

Skyping

[HarryC]

Thanks Skyping
will wait for your reply

[skyping]

Hi Harry,

Please see attached.....hope this helps.

skyping

[HarryC]

Thanks Skyping
That has given me a starting point.

[skyping]

Great....try the attached which includes tables.

Skyping