klutz
11-08-2009, 06:03 PM
Hola to everyone,
I have an excel file in which there is drop-down box that can contain up to 30 country names.
When I manually choose a country a host of data is populated on the excel template. I then click on a print command button and it print the complete template with the country data.
If I have 3 country the task is easy. But when I have 30 countries I have to do this to each one individually.
Is there a way thru VBA that a macro can do this?
The Klutz...:beerchug:
I have an excel file in which there is drop-down box that can contain up to 30 country names.
When I manually choose a country a host of data is populated on the excel template. I then click on a print command button and it print the complete template with the country data.
If I have 3 country the task is easy. But when I have 30 countries I have to do this to each one individually.
Is there a way thru VBA that a macro can do this?
The Klutz...:beerchug: