Calendar and Deadline List

[emf893]

Hi there,

I'm looking to make a seamless calendar that then lists the information off to the side by date, too. I have my calendar set up. I'm looking for a way to have Excel look at the day, notice if there is anything in the cells that make up that day (each task is its own cell), and if so, populate to the list on the right side (example shown). If not, Excel should go to the next day. Is there a way to do this? Would it be better to do a VLOOKUP somehow and build information in a separate sheet?
Example.png

Thanks in advance!

[Pete_UK]

Are you saying that you enter data directly onto the calendar and that you want to produce the list from it?

I have several calendar files which work the other way round, i.e. you list events and dates on one sheet and then a calendar sheet places those events on the appropriate day of the calendar (for which month and year can be selected via drop-downs), with up to 10 events being displayed for each particular day.

It would help if you attached a sample Excel workbook, explaining what you want to achieve.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Don't try to use the Paperclip icon for attachments, as it doesn't work on this forum.

Hope this helps.

Pete

[emf893]

Thanks! It is attached now.

[Pete_UK]

Are those colours added manually? We can't do anything with a formula to use the colour (pink) to determine if an entry should be included on your Deadline list - is there some other way to indicate that an entry is a deadline item?

In your example file all the deadline items occur on a Friday - will that always be the case?

As an aside, I was wondering how you would amend the calendar for other months going forward, as there are no formulae in it to generate it automatically from a start date. Would you manually set it up for a new month each time?

I do think it would be easier to set it up the other way around, i.e. use a different sheet to record in any order all your activities (including holidays etc.) and to indicate what type of activity it is, i.e. D for Deadline, H for Holiday, P for Published, E for Event etc. and then you could use these codes to set up conditional formatting automatically on a calendar sheet, where the details would appear on the correct day for the chosen month and in the appropriate colour.

Hope this helps.

Pete