Macro for Printing Selected Worksheets In Excel

I have excel inspection report which has over 200 individual worksheets and an index with hyperlinks top the various sheets.

I would like to add a column with Print as a title "Yes" or "No" and another with number of copies "1" to "3".

What i am looking to do is set up a macro to look at the column "Print" and if the cell adjacent to the link to the relevant page has a yes then to print x numbers of copies of that page and move to the next row and so on and so on. I am very new to VBA so any help would be much appreciated.

Cheers

Does this help?

Please Login or Register  to view this content.

Works absoluteley brilliantly thank you very much for your help, the only niggle is the sheets print in reverse order to the index and i can't figure out quite why?.

Many thanks Paul R

You're welcome. Glad to help out.

This line tells it print from bottom to top.

Please Login or Register  to view this content.

Reason: is VBA to avoid missing rows when it runs. Hope it is not a major issue. If so I could sort the Columns first. If not don't forget too mark the thread as solved.