Hi everyone,

I have created a calendar where I enter a day and starting date and day and it produces the date and day for 1 year.

The workbook is to manage a work schedule.

One worksheet produces work due dates.

What I would now like to do is automate things so that the calendar automatically corresponds to the work due on that particular day.

So if I have a list of 10 jobs due on Monday, Septemer 1, to the value of £100I'd like the calendar to automatically input the value of that work for Sept 1.


I'm guessing the answer would involve ranges - something I've never used before.

In each cell of the 365 days I imagine I need a formula which searches the next due date column, and picks out all those which match the date column of that row and adds them up to give the total value.

What would that formula be if the next due column is 'Round'!L16:L1016 and the price per job column is 'Round'!G16:G016

(Bear in mind that the column with the calendar date in (B10:B375) is subject to change if I alter the starting date, so the automated entries of what is due would need to change in harmony with the date.)