Archiving Data

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.

I don't where you obtained the 40K figure from ...

but for Excel 2007

4 billion formulas that can depend on a single cell

(From Microsoft)

... As pointed out by PFDave, VBA might be a better option.

I never seen a post on this forum with large volumes of data (100,000+) rows where formulae have been a constraint.