Linking Worksheet/Workbook

  • Thread starter Thread starter newbie
  • Start date Start date
N

newbie

Is it possible to link worksheet/workbook.
What I want is to link worksheet/workbook in such a way that, when I enter
any value in a worksheet, the same value get entered automatically in the
linked worksheet/workbook.
If possible please let me know how to configure the worksheet/workbook.
Regards.
 
You can link cells in two different worksheets in different workbooks.

Open both workbooks.
Select the cell that you'll be typing the values in
Edit|copy
select the cell in the other worksheet that should be linked
edit|paste special|click paste link

If you close the original workbook, you'll see that the linked cell's formula
has changed to include the path and folder.

This is a one way street. You can't update the cell with the formula and have
the original cell get updated. Excel likes to pull data from one
location--formulas can't "push" values to other cells.
 
Thanks Dave,
Will try out today.
Regards.

Dave Peterson wrote:
|> You can link cells in two different worksheets in different
|> workbooks.
|>
|> Open both workbooks.
|> Select the cell that you'll be typing the values in
|> Edit|copy
|> select the cell in the other worksheet that should be linked
|> edit|paste special|click paste link
|>
|> If you close the original workbook, you'll see that the linked
|> cell's formula has changed to include the path and folder.
|>
|> This is a one way street. You can't update the cell with the
|> formula and have the original cell get updated. Excel likes to pull
|> data from one location--formulas can't "push" values to other cells.
|>
|> newbie wrote:
|> >
|> > Is it possible to link worksheet/workbook.
|> > What I want is to link worksheet/workbook in such a way that, when
|> > I enter any value in a worksheet, the same value get entered
|> > automatically in the linked worksheet/workbook.
|> > If possible please let me know how to configure the
|> > worksheet/workbook. Regards.
|>
|> --
|>
|> Dave Peterson
 
Back
Top