Link to home
Create AccountLog in
Avatar of Bright01
Bright01Flag for United States of America

asked on

Assistance with "Moving things Around"

EE Pros.

I have a fairly complex graphic that needs "adjustment".  Attached is the sample graphic.  If you slect an "Outcome", cell B2, it will be copied to cell B 16.  If you then select the "Outcome" in B16, you can slide the sliders and when you "Set the Value", it will post to the Chart.  Pretty cool.  Here's the challenge,

I want to move the outcome in B16 to start in B4 and move the sliders to B16.  That means the sliders and the associated formulas need to be moved down a number of rows.  I can't get it to work when I either insert cells, cut and paste, or move.  I think it has to do with the associated macros.

Thank you in advance,

B.
Priorties-Graphic.xlsm
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

Your code is extremely closely tied to the worksheet layout and uses hardcoded cell references, which is part of your problem. I suggest you use named ranges instead which you can then move in the UI without having to alter the code (some of the code does this already, some doesn't, which doesn't help)

If you move B16 to B4, what are you planning to do with the B12 selection cell? It can't go below the selected outcomes cells because that will break the code.
Avatar of Bright01

ASKER

Rorya,

Thanks for the comments!  If I add a range name for the space between B16 and B4, how do I move it?  Do I add rows, or just shift things around?  Is the problem with B12 being below a big deal in the code?  Here's my problem, the way it is designed, does not lend itself to the right "flow".  You should select the Outcomes, then select a single one (what happens now in B12)  and then use the sliders to apply the values.

Any ideas would be much appreciated.

B.
It depends. If you are ok with having a fixed space for selecting outcomes (say B4:B11), then it should just be a small tweak to the code.
That's actually "more then enough".  The graphic gets rather crowded if you get more then 5 or 6 colored balls.

B.
OK, I think I've updated all the code and added some named ranges. There seems to be some data missing from column E to drive some of the formulas in your sample?
Priorties-Graphic.xlsm
Rorya, Great work!  One glitch....when you choose the Outcome and rank it, I get a #Ref instead of the actual Outcome Identifier on the ball itself.  The Ball should show the identifier or in this case "the comment".  Can you tweek it?

Much thanks,

B.
ASKER CERTIFIED SOLUTION
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Rorya,

You are "exceptional"!!!  Thank you very much!  Not always easy to answer the questions I throw at EE but you and a select group of top flight technical experts continue to amaze me.  My Excel skills continue to grow due to the outstanding work you and the Team provide. Best value for the dollar "ON THE PLANET".

Again, thank you,

B.