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)