Hi All,
I have to do a project management work for my group. We have nearly
300 projects with different information in each column. In the past,
we just put all of them at one single worksheet. Obviously, it's
getting much harder to find the information since more people start to
use it (and mess it up) and the table is getting longer and wilder.
Now I try to divide them into different worksheets by project
dirctors. Then they can focus on their own projects.
But I also need to keep the "Total" worksheet, which contains all of
the projects and information, for my boss. So he can check whichever
he likes without jumping among all the worksheets. Is there any way to
synchronize data value across two worksheets in one workbook? For
example, I put some data into sheet1, it will appear on sheet2 (but
not the same cell) simultaneously.
I'm using Excel 2003 SP3.
All comments or suggestions will be very helpful!!
thanks,

LOLO

See help on "linking"

Basically you need a formula in sheet2 that links to sheet1

=Sheet1!A1 entered in any cell of sheet2


Gord Dibben MS Excel MVP


On Wed, 19 Dec 2007 09:49:18 -0800 (PST), wrote:

Hi All,
I have to do a project management work for my group. We have nearly
300 projects with different information in each column. In the past,
we just put all of them at one single worksheet. Obviously, it's
getting much harder to find the information since more people start to
use it (and mess it up) and the table is getting longer and wilder.
Now I try to divide them into different worksheets by project
dirctors. Then they can focus on their own projects.
But I also need to keep the "Total" worksheet, which contains all of
the projects and information, for my boss. So he can check whichever
he likes without jumping among all the worksheets. Is there any way to
synchronize data value across two worksheets in one workbook? For
example, I put some data into sheet1, it will appear on sheet2 (but
not the same cell) simultaneously.
I'm using Excel 2003 SP3.
All comments or suggestions will be very helpful!!
thanks,

LOLO

Thank you very much!