Auto entry Calendar

[Mark Anderson]

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.)

[reggie1000]

hi mark,

can you post an example of what you are looking for, without definitive cell references it's difficult to help

thanks reg

[Mark Anderson]

Hi,

Please see

http://www.excelforum.com/excel-work...-calendar.html

Where I have uploaded an example (although slighlty different to the explanation above it will give you the idea of what I mean)

Thank you