Linking a worksheet

B

babygoode

Is it possible to copy a worksheet and link it into another one - s
when I update worksheet A it automatically updates worksheet B
 
P

pdberger

BG --

Do you mean "worksheet" or "workbook"? Actually, either way it's the same
basic approach. To pull information from one sheet to another inside the
same workbook, select the target cell (to be updated), press '=', then select
the source cell, and press enter. You can also make that reference part of a
larger equation.

Pulling info from another workbook is same process. Have them both open.
In the target cell, press '=', then select the source cell in the other
workbook. When you open the target workbook, it will automatically open the
other workbook to get information from it. Again, you can use that refernce
as part of a larger equation.

HTH
 
B

babygoode

Sorry I didn't explain it very well.

I have a master workbook with about 10 different worksheets in all for
different people. I want to give people access to their own worksheet
but nobody else's - is there any way of linking the worksheet to
another excel workbook so the people can only see their own data.

Hope that make sense
 
Top