Thread
:
how to synchronize data value across two worksheets in one workbook?
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
Posts: 22,906
how to synchronize data value across two worksheets in one workbook?
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
Reply With Quote
Gord Dibben
View Public Profile
Find all posts by Gord Dibben