Not to worry - and thank you for trying! Since my earlier post, I've been
playing with the following idea: I've created Sheet 3, where Column A2:357
is the consecutive days of 2007 (and Column B is the serial date, for ease).

Now all I need to do is to figure out a function that will find every
occurence of A2 (1/1/07) in the start date column of my projects worksheet,
grab the project task info from the next column, and plonk it all back in C2
of Sheet 3!!

It should be easy, but it ain't.

Regards, & thanks again for your efforts.

"Max" wrote:

Think I'm out here. But do hang around awhile for possible responses from
others.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Vibeke" wrote in message
...
Hi Max, Thanks for your input. Your idea had also occured to me, but it
doesn't really achieve what I'm after. I'm trying to take a whole bunch
of
information (not just projects) from other spreadsheets and accumulate
them
all in a calendar spreadsheet. My other information is not a problem -
one
column is the date (chronological) and the next columns are categorised
text
(ie meetings, report deadlines, signifcant events, etc), which is then
picked
up, column by column, by a VLOOKUP into the calendar spreadsheet, where
the
top row is the date, and the rows beneath it pick up the text in meetings,
report deadlines, etc.

With the project data, I'm really trying to mimic MS Project, so I can
keep
project information in one sheet just like the CF idea, but also transfer
the
start and end dates into the calendar. However, as mentioned before, the
duplication of dates across the many projects means I can only get the
first
project ending or starting on a particular date using VLOOKUP. If there
was a
way to get Excel to accumulate all the multiple projects starting or
ending
on a particular day (and it would be acceptable to have a row in the
calendar
for "Projects starting" and "projects ending") - well, that would be
wonderful!