I am an experienced Excel user who has never recorded a macro. I've always followed a very intense click sequence to format and save 20 individual spreadsheets each week..
I'm trying to use the Record Macro function but have a problem. Once I record a macro to save and try to run it on the next spreadsheet it renames the 2nd sheet with the name on the first sheet when the record button was on. I want to name it to the name of the current sheet I'm running the save macro on.
I've never used VBA coding, and trying to avoid it. I simply want each sheet to be saved with the name it had when opened after formatting..
Example:1st sheet name 6 14 21 AC 214 972 469.(recorded macro using this spreadsheet)
2nd sheet name 6 14 21 AC 281 713 832. Run save macro and it's renamed to AC 214 972 499
and all 20 following spreadsheets.