I am looking for a macro which will copy data from a mastersheet (basically a refresh from Essbase based on country selected from a dropdown list). I have a number of tabs for each country. I need the data from the mastersheet to then be copied to specific country tab. I have attached a simplified workbook which should help me. So I have the 'Engine' tab which is the essbase download. I have a dropdown menu on the mastersheet (Engine) for countries, based on which I get the data. If I pick France and get the data for France, I want the data to populate the 'France' tab. Worksheet layout is going to be the same for the Master sheet as well as for country tabs.
Appreciate any help on this. Thank you.
Krish
Bookmarks