Calendar from Excel data

[David M. Marcovitz]

Sorry for the crossposting; I posted this in the microsoft.public.excel
group, but that group seems to have been replaced by this group (at least
it has much less traffic than this one and is much harder to find online),
and I didn't get any responses there so here goes...

I currently keep a fairly complex calendar as an Excel spreadsheet. I would
like to find a way to automatically generate a normal-looking month-by-
month calendar from this. I really don't need the month-by-month calendar
to show much of the complexity, just the events and times and possibly
locations in the correct dates on the calendar.

I did a little looking on the web and saw many calendar systems, but it
wasn't clear to me which might be able to import my data from Excel.

--David

 

[Gary''s Student]

Consider strating with a standard template:

http://office.microsoft.com/en-us/templates/TC101944531033.aspx?CategoryID=CT101425391033

 

[David M. Marcovitz]

Thanks. The template is fine, but that's the easy part. I want to get the
data to automatically fill in the template with events on the right days.
By the way the final calendar doesn't have to be in Excel; it just needs
to easily get its data from Excel.
--David

=?Utf-8?B?R2FyeScncyBTdHVkZW50?=

 

[Gary''s Student]

The first step is to copy the template into your original workbook. This
makes linking much easier.

The next step is to populate the calendar template worksheet with links back
into your original complex calendar worksshet.

You can use things like VLOOKUP() to get information w.r.t specific dates,
etc.

 

[David M. Marcovitz]

I guess I'm being a bit dense, but I don't see how this would work. I have
the calendar template as my second sheet in the workbook, but I don't see
any way to automatically populate the cells. I can't even find a good way
to figure out what date each cell is so that I can find the several lines
in the main sheet that match that date and add those to the cell.

I have many more columns than this, but the basic information can be found
in the columns: Event, Date, and Start-Time. Each of these columns might
have several events happening on the same date that should appear on the
calendar in the same date box.

--David

=?Utf-8?B?R2FyeScncyBTdHVkZW50?=