Need Help Wirting a Macro that will copy data from a sheet to many

[markwilliams2004]

I am trying to write an excel macro that will copy a range called "Data" on sheet 1 into a series of sheets that are indicated by a range called "CountryNames" on sheet 2. So for each sheet I want to copy the information to there is an entry in the range containing that sheet name.

I cannot simply copy to all sheets in the workbook since not all sheets need the information copied over.

Any help is greatly appreciated.

 

[Swi]

If you are indeed wanting to write a Macro in Excel to do this you should post this in the following forum:

forum707

Swi

 

[markwilliams2004]

Thank you. I appreciate your help.