Select solution type from Drop down list, the final output table should reflect in new she

Dear Members,

I need help for my problem on excel.

I have done all the computation and final output was in the form of tables with different solution sets in one worksheet in an excel.
From the dropdown list (List of solution models), when I select one solution set it should pick that particular workout and populate the final output table in the new worksheet in the same excel. Firstly, I need to establish dynamic linkage between the drop down list and final output tables and then push the final table to new worksheet based on the option selected.

I am not very versed with excel macros, VB. So, please provide the detailed solution if possible.

Thank you.
SV

Welcome to the forum. Pls take some minutes and read forum rules.


This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.