Possible formula question

  • Thread starter Thread starter nswhite
  • Start date Start date
N

nswhite

I am working with a workbook and wanting to pull a number from one
spreadsheet into another that will auto update as the pulled number is
changed. Any help would be greatly appreciated.

Thanks,

Nate
 
Nate:
This is called an "external reference" and it is explained pretty well in
the Help Section under that title "External Reference" it allows you to link
the contents of a cell in one workbook (the source) and have it appear and
be updated in another (the Destination)

Good luck.
Gene L
 
Thanks for the help

Gene L. said:
Nate:
This is called an "external reference" and it is explained pretty well in
the Help Section under that title "External Reference" it allows you to link
the contents of a cell in one workbook (the source) and have it appear and
be updated in another (the Destination)

Good luck.
Gene L
Click to expand...
 
See Excel help on "linking" or "links"

Basically you use a formula to link cells from one workbook to another.


Gord Dibben MS Excel MVP
 
Back
Top