Copy multiple worksheets to new workbook

[bnadarevic]

Hi there,

I would like to copy two worksheets, one with graphs that are linked to the second one with formulas to a new workbook and rename them. Can anyone help?

thank you

Baja

 

[SkipVought]

Hi and welcome to Tek-Tips,

Turn on your macro recorder an record doing what you want.

Turn off the recorder and observe your recorded code. Modify the VBA as required.

If you need further help, post your recorded code, along with specific questions.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}