Calendar from Excel data
 

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

Calendar from Excel data
 

Consider strating with a standard template:

http://office.microsoft.com/en-us/te...CT101425391033


--
Gary''s Student - gsnu200752


"David M. Marcovitz" wrote:

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

Calendar from Excel data
 

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

?B?R2FyeScncyBTdHVkZW50?=
wrote in
:

Consider strating with a standard template:

http://office.microsoft.com/en-us/te...3.aspx?Categor
yID=CT101425391033


--
Gary''s Student - gsnu200752


"David M. Marcovitz" wrote:

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

Calendar from Excel data
 

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.
--
Gary''s Student - gsnu2007a


"David M. Marcovitz" wrote:

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

?B?R2FyeScncyBTdHVkZW50?=
wrote in
:

Consider strating with a standard template:

http://office.microsoft.com/en-us/te...3.aspx?Categor
yID=CT101425391033


--
Gary''s Student - gsnu200752


"David M. Marcovitz" wrote:

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

Calendar from Excel data
 

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

?B?R2FyeScncyBTdHVkZW50?=
wrote in
:

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.