I have a file with a macro that creates a new sheet named New Record. We use this new sheet to enter data and then rename the sheet 2010Q1, 2010Q2 etc to represent the year and current quarter.

I now want to have a macro that is capable of coping anyone of the sheets or mutiple sheets (depending on which tab(s) I want to copy at that time). What would be even better, if possible, is to export the requested sheet to a PDF.

Anyone know if this is possible and if so, how?

thanks,