Creating new workbook for each sheet in workbook

[juliaharry123]

Hi

I would like to run a macro from a worksheet that creates a new workbook for each worksheet (there will be 20 plus) and saves it in a new folder i.e. all the same directory L/Utilisation/Team/name of the worksheet

How would I do this?

Many thanks

Julia

I am a beginner in Macros, been on a course and now trying to use it.

[ranman256]

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.