Macro to copy specific sheet

[mjhopler]

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 (depending on which tab 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,

[JBeaucaire]

This will present a little popup of all the sheets in the workbook. Select one and it will copy that sheet to a new workbook.

Please Login or Register  to view this content.

[mjhopler]

This worked perfect, thanks. However, the game plan has changed. Now we need to be able to export multiple sheets at one time, I know we could just run this macro multiple times and copy them into one workbook, but the goal is to make this as user friendly as possible for our client. Is it possible to adjust the code below to allow exporting multiple sheets at one time?

For example, say I have four sheets, Sheet1 through Sheet4 and want to export three of these. Next time I may want to export only two sheets etc…

Thanks,

[JBeaucaire]

Try this...it will select all the sheets you want, then copy them to a new workbook, then deselect them in the original workbook again.

Please Login or Register  to view this content.