Hi,

My goal is to have an excelsheet summarizing the activities over time of all
departments in my company. The sheet would work as follow. On a "detail"
sheet, users would input details of projects like: start date, subject, end
date, person responsible...This information should directly feed another
sheet called "Overview". This sheet would visually show all entries in the
"detail" page. For instance i would have a calendar and colours would fill in
the cells whenever there is a project going in the department.
was wondering if anyone could lead me on how to feed one sheet with an
information entered in another sheet.

Thanks a lot for your help,

Regards,

Jeremy