I have a Main file which is xlsm sheet that has 4 tabs Instructions, Project Data, Sheet1 and Sheet2.
I want help in a macro or new Macro where in I want to copy all data in Sheet1( into a separate new workbook ) and save it with a standard naming convention that I have. How do I do that?
Beware that the Sheet1 data currently has say 13000 records in March but the coming months it might change basically the records are dynamic so whenever the Macro runs say in month of April for eg the records might be 14000 for example and so on and so forth for the other months.
Also whenever this new workbook is created I want the Sheet name to always be Sheet1.
I want to repeat the same process for Sheet2 as well but only change is that the name should be Sheet2 in the new workbook. I can try and replicate this if Sheet1 is successful.
Let me know if this can be done.
