I need a macro that archives a worksheet to a different workbook each time I press the "Archive" button.
Each time I archive, a new worksheet needs to be created in the workbook and takes all the necessary data, being all data on the worksheet.
Each worksheet includes a variable which tracks the event date (from a pull down, not real time), called RDate.
I need the tab to be named with the current value of RDate each time the archiev is run, and a new sheet created each time, unless there already is a sheet with the same name in which case I get a dialog to ask whether to overwrite existing sheet.
Any halp on this one would be really appreciated
Each time I archive, a new worksheet needs to be created in the workbook and takes all the necessary data, being all data on the worksheet.
Each worksheet includes a variable which tracks the event date (from a pull down, not real time), called RDate.
I need the tab to be named with the current value of RDate each time the archiev is run, and a new sheet created each time, unless there already is a sheet with the same name in which case I get a dialog to ask whether to overwrite existing sheet.
Any halp on this one would be really appreciated