What is the best way to use a macro to save a worksheet separate

Hello


I'm attempting to save a worksheet separate from my worksheet. I started a simple macro where as soon as I start recording, I right click the worksheet and "make copy in a new workbook." This works well enough, but I would like to set the macro up to automatically save the worksheet using designated text as the worksheet file name.

For example:

I copy a worksheet into its own workbook. In cell A1 of that worksheet the title is "Budget"

How do I get the macro to recognize whatever the text is in cell A1 and then save it as the file name and onto my desktop?

The title of my worksheet will change often.

Is it possible to use the macro to recognize ANY text so long as it is within the designated cell, ( A1 ) ?

Also, I have some formulas in this new worksheet which is now saved separately into it's own workbook. Is it possible to erase the formulas yet still leave the data?

Thank you!

Please Login or Register  to view this content.

Is it possible to use the macro to recognize ANY text so long as it is within the designated cell, ( A1 ) ?

You can't use slashes and there may be other forbidden characters.

Also, I have some formulas in this new worksheet which is now saved separately into it's own workbook. Is it possible to erase the formulas yet still leave the data?

You can copy the data and paste special values to obliterate the formulas and there are probably other ways