Macro Printing information from Dropdown menu

Niki_Ivanov

New Member
Joined
Aug 11, 2017
Messages
6
Hi There,

I was wondering if you could help me out with a Macro i desperately need to easy my work.

I have a sheet with 2 drop-down menus and a bunch of tables underneath. 1st dropdown menu represents 1 criteria - example REGION . 2nd dropdown menu represents 2nd criteria - different customers in that region. When i select a customer it populates the table with data from another tab.

Now what i would like to have if possible at all is i want to print the tables from that sheet for each customer in the selected region .. so instead of selecting a Region from dropdown 1 and then clicking each customer and then printing i would like to just select the region and then start a macro which will automatically go though all customers and send them to the printer ?
I hope i explained it well . Every help will be appreciated. Let me know if additional info is required ! Thank you in advance !

9cO9vwv.jpg

Kind regards,
Nikolay
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Forum statistics

Threads
1,224,815
Messages
6,181,135
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top