Moving Worksheets to Workooks VBA

[gallen6945]

Hi all,

Can someone help me with code to move a worksheet to a new workbook and save the file as the name of the worksheet. I have a spreadsheet with hundreds of tabs which need to be copied into a workbook titled by the tab name.

Example attached -

So move Tab called A to a workbook titled A
Then Tab B to a workbook titled B

All data needs to be captured.

Thank you.

[Tajan]

Check this:

Please Login or Register  to view this content.

[gallen6945]

Superb - thank you!!!!

[gallen6945]

Could you also assist me with the following code - I am trying to save the file (which has been formatted to print area , page setup etc) but I need to save the file as a PDF document in the same location as the Excel file?

Please Login or Register  to view this content.

[Tajan]

Check this:

Please Login or Register  to view this content.