I have a workbook that is updated in ~30-90 feet intervals, over a period of 10,000 feet. The workbook becomes quite large and ideally I would like to have a macro to archive all but the 5 left most tabs, hidden sheets, and the first sheet in the workbook named Logs. Would it be possible when running the macro to be prompted to create(or automatically create) a new file with the same file name but with a prefix archived? Then all subsequent uses of the macro, look to see if the archived file is created and if so, add those unused sheets to the archived file too?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
