G
Guest
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
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