I need help with a print macro. I have a file with multiple tabs (each tab having unique information) including a data entry tab. On the data entry tab, I want to put a button that will allow me to print a specific number of pages from each tab based on a specific cell value on that tab.
For example: Cell M1 on each tab will contain a number. That number represents the number of pages to print.
Tab 1: M1 = 2
Tab 2: M1 = 5
Tab 3: M1 = 3
The print button should then print 2 pages of the data on tab 1, 5 pages of the data on tab 2, and 3 pages of the data on tab 3.
Can anyone help me with the macro needed to do this?