Archiving Data

[kunal.patni]

Hello Team,

I've noticed certain limitations of excel, that we can have only 40K cells with formulas per sheet (tab).
I have a sheet with 8-10 columns and I am calculating data for each day, the reason I have formula for each cell. The rows would be increasing day by day(month by month for each member).

I am looking like archiving option where in data from current sheet will be archived to some other sheet/tab/file, when it reaches maximum cells/rows.
And calculation would begin again with current data/day.

For e.g. Please see attached file.
Companies Tab: Contains sample data, here it's just for few peoples and few months and there would be many more.
Results Tab: Contains formula for each cell to calculate data.

So, Lets say Results tab reaches it's maximum limit at 31st May, it should archive data to some other tab/file.
And calculation should begin again from 1st june in same sheet(Results tab).

Thanks for your help in advance.