Macro to split worksheet by date

[Chunky_22]

Hi All

I have a fairly large sheet sorted by date. The earliest date is 01/04/2010 (01 April). The dates appear in column G. Rows 1 - 5 are header rows, so the first line of data is row 6.

I need to create multiple workbooks, one for each month that have the 5 header rows at the top, and then all the data for that month. I also need the file to be saved automatically to a location on my computer, including the Month and year in the file name.

My current data range (under the header rows is A6:AF8102 but this could change for future files.

Could someone assist with this please? It would be a great help.

Thanks in advance

 

[AlphaFrog]

Even though the new workbook is visible, the macro code still filters and copies from the original worksheet. So that shouldn't be the problem.

The macro does work on my test data.

 

[Chunky_22]

Thanks for all your help with this so far. There must be something in my data that is preventing it from working. I will endeavour to find the issue.

Much appreciated