Hi.
I'm trying to do the following at my work:
Use a master sheet where some employees type in information regarding projects. This sheet will be protected so that only some can type in information. (this is OK)
We want to create a database regarding completed and ongoing projects. How can I make Excel use information from the master sheet to copy information to the sheet we want without us updating our status twice?
Example:
Sheet 1 - Master - Project X - Ongoing | Project Z - Completed
Sheet 2 - Ongoing - Project X - Ongoing (information gathered automatically)
Sheet 3 - Completed - Project Z - Completed (information gathered automatically)
Sheet 2 and 3 will be used in reporting to project managers and customers.
Hope this is enough information for someone to help me.
Thanks in advance!
Bookmarks