OK, so there are ways to save active sheet into new sheet using macros where the parameters needed are the current sheet and new sheet name.
But what I want is to copy the data on active sheet or from any other sheet for that matter into a single workbook every time I click on the macros. But the sheet should automatically save with date and time as paramters.
If I click now a sheet should be added with 04.19.11.07.49.56
and tomorrow a new sheet with new date and time as the sheet name
But what I want is to copy the data on active sheet or from any other sheet for that matter into a single workbook every time I click on the macros. But the sheet should automatically save with date and time as paramters.
If I click now a sheet should be added with 04.19.11.07.49.56
and tomorrow a new sheet with new date and time as the sheet name
