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!
Bookmarks