asked on

Demo Macro Script

EE Pros,

I'm putting together a Demo tab so as to pre-load information concerning a particular ability to demonstrate using 3 columns of data. Upon selecting the Demo to run, the data should automatically populate the other two tabs. Change the demo, and the data should also change.

That's it! Thank you in advance.

B.
Demo-Script.xlsm

Saqib Husain

Copy this to F9 of customer box and from there copy it to each of the other boxes

=INDEX(Demos!$E$8:$G$13,MATCH(E9,Demos!$C$8:$C$13,0),MATCH(Demos!$D$3,Demos!$E$6:$G$6,0))

Bright01

ASKER

Ssaqibh,

Thanks for the quick reply. I'm looking for a macro ("Upon selecting the Demo to run...."), that when fired, will populate the Customer and Pricing Tabs. This is because, without firing the Macro for the Demo, the user can enter their own information (so I can't use a formula in the cell).

Make sense?

B.

ASKER CERTIFIED SOLUTION

Saqib Husain

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Bright01

ASKER

Thank you! Works great..... I can build with it.

Have a great Thanksgiving!

Bright01

ASKER

Ssaqibh,

Actually, While this works, I have some issues as I incorporate this solution. I'll be authoring a fix question.

The major issues are I cannot work easily with the RC approach as reference points. What's missing here is the macro doesn't use the Reference Cells which is why I put them in the Demos Tab.

Hope you will pick it up.

Thanks,

B.