Macro to select multiple categories and percentages.

Hello

I have a macro project that needs some adjustments. The first attached spreadsheet (Carve-Out) has a pdf, results, data, and list tab. There is a macro built-in to the purple button, that allows the user to choose up to three categories, and would copy from the data tab and paste into the results tab. This was set-up so that only one percentage could be selected.

The first spreadsheet works great (thank you MarvinP), however, I need to be able to select up to eight categories all with different percentages as seen in the Carve-Out 2 file. So the end user would select up to eight categories, select different percentages for each category, click on the purple button, and have everything populate below. The % for proposal would be the 2011 Medicare number * the percentage chosen.

Any help on this would be greatly appreciated.

Thank you.

Hi rygon8
Just trying to understand. If 2011 Medicare Value = 10% off MSRP and % selected were 110% what would % for proposal look like in this formula

% for proposal = 2011 Medicare Value * % selected

I get

% for proposal = 10% off MRSP * 110%

but I don't know what that evaluates to.

Hi rygon8
If a procedure were to apply the formula, it'll return "#VALUE!". What do you wish the procedure to return?

Hi rygon8
This code is in the attached

Please Login or Register  to view this content.

I've changed a few lines of code in your original procedure and added lines to do the math. Step through the code to see what it's doing. I see an issue if a user populates B2, leaves B3 blank and populates B4 (try it, you'll se what I mean). This can be handled if you like. Let me know of issues.

Hi rygon8
Ha! I see what you mean

is there anyway to leave the header as "% for proposal"

I do set it back here

Please Login or Register  to view this content.

but overwrite it here

Please Login or Register  to view this content.

Sorry 'bout that...didn't notice it. Easy fix.

Regarding this

I do see what you mean if a user populates B2 and leaves B3 blank, is this fixable ?

Yes, i think it's fixable. I have a personal project that has similar requirements...I'll adapt the code from there. Get back to you on this.

Hi rygon8
Fixed this

is there anyway to leave the header as "% for proposal"

Think I fixed this

I do see what you mean if a user populates B2 and leaves B3 blank, is this fixable ?

Try it...let me know of issues.

Hi John

I may have found a potential problem. I have attached the most recent spreadsheet, the way it is currently set the user cannot change the %, on cell E2. It says "the preceding row can't be left empty". Also, if I only select one category, I think the code gets caught in a loop?

Let me know if any of this is fixable.

Thank you.

Hi rygon8
See if this version resolves both issues for you. Let me know of issues.

You're welcome. Let me know if something else comes up.

Hi rygon8
I think we have it surrounded...keep pounding on it...see if you can break it. This version seems to have this issue resolved

the % for proposal (cell F14). Always calculates as manually calculated

Sorry I didn't notice that.

Good to hear. You're welcome.