2 years worth of dated data - Split it per week/month on a new tab (pivot not possible)

[Fraser1989]

So I have 50k records that I am looking to split into new sheets per week and/or month

Now I can do this manually, however the report needs to run once a day and there is potential for new data to appear in each daily report.

I get that excel is not the tool to use for this (as I already have the data displaying as I need it to using powerbi and Qliksense) but in terms of running it as backend reporting, for one internal function, it has to be in an excel file (long story short, data needs to be copied into one source file in excel and it's then taken from that)

Anyone?

 

[alansidman]

Use XL2BB to show us 10-15 records and your expected results.