I need to create a macro that will delete all sheets in a workbook that do NOT contain the substrings "Dec" and "09". All other sheets in the workbook may contain some variation of the months of the year (e.g. October 09, Sept 09, Jan. 09, etc)
Some workbooks will contain 2 or 3 sheets with "Dec" and "09" in them while most may just contain 1 sheet with those substrings. How could I alter the code to handle these scenarios?
Once all the other sheets are deleted, I need to make a copy of the remaining December sheets and rename them to January. This needs to be done for all workbooks in a folder. Any suggestions would help tremendously!!
Some workbooks will contain 2 or 3 sheets with "Dec" and "09" in them while most may just contain 1 sheet with those substrings. How could I alter the code to handle these scenarios?
Once all the other sheets are deleted, I need to make a copy of the remaining December sheets and rename them to January. This needs to be done for all workbooks in a folder. Any suggestions would help tremendously!!
