Macro needed to copy data from master sheet to a number of specific sheets

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

Hi Fshbet,

Thanks for the quick response. That's awesome. Is it possible to have the cells copied across as values rather than copy formulae across as well.

Rgds

Krish

Hi Yasser, Thanks for that...works well. I will run it tomorrow on my actual file at office and will come back if there are any issues. Thanks to you and Fshbet for the quick response.

Thanks, Fshbet. Will work out both options at office and let you know if I run into any problems or if I need any further tweakings.

Hi all...apologies as I got pulled into other projects and this one took a back seat. Now I am back taking a look at the above issue. To recount, I am looking for a macro which will help copy data from the master sheet to a number of specific sheets. The macros provided by Ravi(fshbet) and Yasser worked absolutely fine..thanks for that. However I need a further tweak. The macros provided by Yasser and fshbet require me to pick a country from the dropdown list and then it populates that particular country's tab with the data. I now want the macro to be iterative i.e. pick the first country in the dropdown menu on the 'Engine' tab, copy the data to that country's tab, then pick the second country from the dropdown menu and copy that data to the second country's tab and so on until there are no more countries in the drop down menu. I am attaching the file. I have included a 'data' tab to put some numbers into the 'Engine' tab but in reality, the data on the 'Engine'tab will be a retrieval from Essbase (I can plug in the essbase retrieval macro wherever necessary). So the way the template works is
1. pick first country from dropdown list
2. refresh data from essbase
3. copy data (only values)to that country's tab
4. go to Country 2 on the dropdown list
5. refresh data
6. copy data (values) to the second country's tab....and so on until the last country in the dropdown menu is reached.
Could really do with some help from the aces.
Thanks

Hi fshbet,

Thank you so much for your help. The macro worked fine. Really appreciate your help and the quick turn around.