Generating calendars

D

DKS

Hi,

I have a spreadsheet in which there is one column of date and a second
column with the event description. Of course there are many other columns
but these 2 columns are of interest for this particular question.

For the same date i could have several events, upto 3 or 4.

I would like to know if there is some routine available that I can use to
transform these 2 columns into a calendar like look and feel (one month at a
time, thus a 7x5 matrix where 7 columns are for the 7 weekdays and the 5 rows
are for the weeks. In each 'cell' I would like to have the date shown and
the 3-4 events.

All help appreciated.
 
P

Pete_UK

Yes, I put something together like this for another respondent some
time ago. It copes with up to 8 events per day and displays them in
calendar format on another sheet, where you can select the month of
interest and print it out.

If you would like a copy of the file send me an email to:

pashurst <at> auditel.net

Change the obvious.

Hope this helps.

Pete
 
A

Amanda

Hi Pete,

This sounds like it could be the perfect solution for a problem I'm working
on. Would I also be able to ask for a copy?

Kind regards,
Amanda
 
P

Pete_UK

Yeah, sure - send me an email to the address given before and I'll
send it back to you.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List all tables, including document structure 0
Create timeline with event being hyperlinks to documents on drive 1
Help with time function 7
Drop-down calendar for sheet 0
Insert Index into a Table 1
Search closest day in the past from today 2
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Problem using IF statement with dates as part of the formula 4

Top