A macro which pulls the data from sheet2 to sheet1 basis of scenarios selected in sheet1

Hello Guys,

I need help in creating a Macro which pulls the data from Sheet 2 (hidden sheet) to Sheet 1 basis of dropdown cell values against all 3 scenarios.

Sheet 2 is a sheet which contains the information against multiple scenarios.

Sheet 1 is a sheet in which user has to select the scenario against which he need an information.

So, basis of all 3 scenarios selected in Sheet1 macro should check the data in Sheet 2 (hidden sheet) and if the scenario matches then pull the data against that scenario in Sheet 1.

A sample file has been attached for your reference.

Thanks
MG

Hi MG

This Code in Module1 and will fire when Scenario 3 is changed (See Sheet Change Event Code)

Please Login or Register  to view this content.