Excel 2007, Window 7 SP1
I would like to be able to enter data into the LOG sheet and have it populate in the calendar sheet. I have tried different macros for calendar picker but my work computer doesn’t have the add-ins required (and no administrator access .

I have used the calendar sheet as the drop downs for the LOG sheet to try and keep the references simple and provide data validation.

Ideally I would like it to display on the calendar page like I have manually entered ie:
Appropriate machine row, location by date, coloured by work type.

Unfortunately this is beyond my meager Excel skills. I am hoping that someone who likes solving this type of problem can help me.
So my guess the cell statement in Calendar sheet for the first LOG line is something like – if date is < or= B3 and <or=C3 and D3= “calendar” A8 then return result E3 and highlight colour “calendar” A12
I have spent hours on google and tried some fairly complex index and array formulas but I don’t really understand them enough to make it work properly.
I am happy to change the format of the workbook if there is an easier way basically so long as the information entered on the LOG appears in the calendar.
Thanks so much

Attached Files

Working summary.xlsx (20.4 KB, 13 views)

Hope this helps

with kind regards,

Cobbe

Attached Files

Working summary(cobbe).xlsm (35.3 KB, 11 views)

Thanks so much for the calendar picker Cobbe. I tried for so long to find something that would work on my machine. This works great!
Now i just need a formula guru to populate the log data into the calendar sheet and this task will go from being my most time consuming to almost pleasant
Thanks again Cobbe

I hope this will help you again.

With greetings from Belgium
Cobbe

Attached Files

Working summary_3(cobbe).xlsm (48.6 KB, 10 views)

Thanks So Much Cobbe!!!
That is exactly what I wanted - and so simple when you know how

The internet certainly makes the world a much smaller place.

With many thanks from Australia