Weekly Workload Tracker - VBA Alternative??

Hello all!

I have inherited a workload tracker that tracks the whereabouts of staff over the course of the months/years. Whatever job they are assigned to and for how many days is plotted onto a table with days/dates down the left (shown as weeks) and names across the top.

When I inherited it, there was a formula in every box of the table to work out whereabouts - this meant there was huuuuuge amounts of it and the spreadsheet was taking a long time to open and run.

Is there a VBA alternative to formula? This would speed up the document no end. I've attached a sheet if somebody is free to take a look?

To briefly explain the document, a job is entered on the first tab and this job should then populate the table on the second tab. I've pre-populated with an example line.

Many many thanks

Hi Richard, the original formulae entered into the cells of the table was:

=IF(C747="","",IFERROR(INDEX('Example Planner'!$B$6:$B$1000,MATCH(1,INDEX(('Example Planner'!$G$6:$G$1000<=C747)*('Example Planner'!$M$6:$M$1000>=C747),0),0)),""))

To explain what it does... once a job had been posted onto the first tab/sheet to a planner, details of this would be reflected on an individual planner's tab/sheet showing workload for them. The table on the second tab would then refer to this. So we would type the location of a store and assign to a planner and back on the table on the second tab/sheet, this store and the length of time the job is taking place would be reflected in that planner's column. This is what I would still like it to do but in a more simple way. We just want workload per planner reflected on the table; entries to be shown by data entered in the 'location' column on the first sheet.

Thank you for your response.

Not a problem and sorry for not including enough info. I've attached an updated sheet showing how I'd like information to appear.

Column C on the first tab shows the location of works, while columns L and N show the duration of the works the planner is required.

On the second tab (the table), this data is represented by putting the location of works across the dates/days in the table. The attached should make it clearer

Thank you again