Hi,
I am looking for help in writing a macro to filter copy the rows in excel and create new sheets. I have attached a template file for help.
The excel can have data for n number of rows and from Column A:CF
In cell B1, reporting month will be given as input in MM/DD/YYYY format. Once the data is input in cell B1, macro should match that data for every row in Column D and once Match found, it should create a new worksheet with Month name and paste all the rows for that month in the new sheet.
Thanks in advance for help
Regards
Paul
Bookmarks