i have a workbook with 30 or so different sheets. the first sheet is a cover sheet offering the ability to print out x number of copies for specific sheets. in the cover sheet we have column "a" referencing all of the sheets available to print and in column b is the number of copies needed for the corresponding sheet. i need a macro that when prompted will print out the desired number of copies with the corresponding sheets. I would also like these referenced sheets to be hidden as to not confuse the user. also if a quantity of 0 is indicated, excel should not print that particular sheet.
example
"cover sheet tab"
column a (a list of the optional sheets to print)
sheet"name1"
sheet"name2"
ect.
ect.
ect.
column b (desired number of copies)
2
1
5
ect.
ect.
Thank you for any help!
Bookmarks