hunsnowboard
06-26-2010, 02:56 AM
Hi Everyone!
I have the following problem and I just can’t solve it.
I have an excel file with two worksheets. One worksheet contain the data of all the countries with all the detailed information. The other worksheet is the print version for my boss. It is a formatted table with just a few data. On this sheet I am able to choose the countries by a drop down list, and when I choose the relevant country, I can see below the figures. My problem is that when I want to print out the information on one country, it works perfectly, I just select the relevant country and then print it. But in case I would like to print all the countries, or just 20 countries I need to select them one by one and print them one by one.
How could I make a print button which when pressed brings me up a userform when I can select the countries with the help of checkboxes and then have the checked ones printed, like it is ont he formatted spreadsheet.
I hope you can understand my problem and you can help me!
Thank you a lot in advance and have a nice weekend!
I have the following problem and I just can’t solve it.
I have an excel file with two worksheets. One worksheet contain the data of all the countries with all the detailed information. The other worksheet is the print version for my boss. It is a formatted table with just a few data. On this sheet I am able to choose the countries by a drop down list, and when I choose the relevant country, I can see below the figures. My problem is that when I want to print out the information on one country, it works perfectly, I just select the relevant country and then print it. But in case I would like to print all the countries, or just 20 countries I need to select them one by one and print them one by one.
How could I make a print button which when pressed brings me up a userform when I can select the countries with the help of checkboxes and then have the checked ones printed, like it is ont he formatted spreadsheet.
I hope you can understand my problem and you can help me!
Thank you a lot in advance and have a nice weekend!