ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Feeds from one sheet to another (https://www.excelbanter.com/excel-worksheet-functions/110823-feeds-one-sheet-another.html)

jgenin

Feeds from one sheet to another
 
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

Carim

Feeds from one sheet to another
 
Hi,

Just type the sign =
and with your mouse go click on the field of any other worksheet,
and hit enter

HTH
Cheers
Carim



All times are GMT +1. The time now is 05:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com