Print Qty of Excel Sheets = cell value macro

Closed
Mark - Jan 7, 2011 at 03:58 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Feb 9, 2011 at 05:10 PM
Hello,

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 plz help me with the macro needed to do this?

Thank you,

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Feb 9, 2011 at 05:10 PM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.


Note:
your data need not be to be real data but a good representative of how data looks like
0