ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Mastersheet update problem... (https://www.excelbanter.com/excel-worksheet-functions/192021-mastersheet-update-problem.html)

MarkV

Mastersheet update problem...
 
Hey there all...
My brain is frying. I need to know if the following is possible.

I am running a small designer business and have three employees each with
their own PC. I have a master workbook with all their names where I can add
projects to each individual person, now my problem is that when they receive
their projects they should be able to fill in details about their projects
and upon saving their workbooks my master workbook should automatically
update, whereas I can determine how far each designer has progressed.
Updating bothways to put it in that context...Hope this make sense..it is
driving me nuts. Please Help!

Stefania

Mastersheet update problem...
 
Hi Mark,

I'm no expert but at my work it happens like this:
If your PC's are all on a shared drive then you can give your workbook
shared access so all of you can be updating it at the same time.

I don't know the answer if you're not though... sorry!
--
Steffi
********
It''s Thank You and Goodnight! :o) xx


"Markv" wrote:

Hey there all...
My brain is frying. I need to know if the following is possible.

I am running a small designer business and have three employees each with
their own PC. I have a master workbook with all their names where I can add
projects to each individual person, now my problem is that when they receive
their projects they should be able to fill in details about their projects
and upon saving their workbooks my master workbook should automatically
update, whereas I can determine how far each designer has progressed.
Updating bothways to put it in that context...Hope this make sense..it is
driving me nuts. Please Help!


Spiky

Mastersheet update problem...
 
On Jun 20, 2:10 am, Markv wrote:
Hey there all...
My brain is frying. I need to know if the following is possible.

I am running a small designer business and have three employees each with
their own PC. I have a master workbook with all their names where I can add
projects to each individual person, now my problem is that when they receive
their projects they should be able to fill in details about their projects
and upon saving their workbooks my master workbook should automatically
update, whereas I can determine how far each designer has progressed.
Updating bothways to put it in that context...Hope this make sense..it is
driving me nuts. Please Help!


I'm no expert on this, but wouldn't Project Management software be a
better choice?


All times are GMT +1. The time now is 11:18 AM.

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