Hello.

Hopefully someone can be of assistance!

I have a workbook with three worksheets - 1st is an event register, 2nd is a calender (manually done, with no formulas due to format problems I couldn't solve), 3rd is a summary.

I am trying to work out the following;
The first column of the 1st sheet (event register) requires a date.
The second column requires an 'event', from a drop box or list (of seven possibilities). These are working fine.

Is there a formula I can use theat when a user enters a date, say 1 Jan 08 (or the format is "Thursday, 1 January 2008") AND a certain event, say "CALL" that this will automatically populate the next worksheet (calender) on that corresponding date (1 Jan 08)?????

There are seven possibilities for each date (eight including "blank" or ""), which I am sure I will be able to extend to each day of the calender once I work this formula out.

I have already formulated the second worksheet (calender) to count the freqency of events into the third worksheet (summary). Hopefully these wont effect the formula I am looking for.

Thanks in advance!