I currently have multiple workbooks with two worksheets, I would like to delete one and rename the other to the name of the deleted one.
For example I have "Data" and "CollectedData" I would like to delete "Data" and rename "CollectedData" to "Data". I am trying to make a macro as all the workbooks I have contain the same naming convention for the worksheets and I am already running a set of macros on the worksheets.
Thanks for all the help in advance!
For example I have "Data" and "CollectedData" I would like to delete "Data" and rename "CollectedData" to "Data". I am trying to make a macro as all the workbooks I have contain the same naming convention for the worksheets and I am already running a set of macros on the worksheets.
Thanks for all the help in advance!