Template that saves first 4 worksheets as separtate file

[jimrosser]

Hi was wondering if anyone had run across this issue before. I have a workbook that I would like to use as a template.
It contains Monthly, Yearly, Budget, Summary and Data tabs. What I would like to do is extract the first four tabs from the workbook
and save to a new workbook with the new workbook name based on a formula in cell A3 of the Monthly tab (changes each time) and directory in cell A4 remains constant for the month.

Thanks,
Jim

[Leith Ross]

Hello jimrosser,

This macro will copy the 4 worksheets: Monthly, Yearly, Budget, and Summary into a new workbook leaving the original worksheets intact. The new workbook will be saved and named using cells A3 and A4 of the Monthly worksheet.

Please Login or Register  to view this content.

[Osvaldo Palmeiro]

Please Login or Register  to view this content.

[jimrosser]

Thanks worked perfectly.