Possible formula question

[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

 

[Gene L.]

Nate:
Are you working with Excel or Microsoft Works?
Gene L

 

[nswhite]

I am working with Excel...I am hoping I am explaining it correctly...

 

[nswhite]

I am working with excel.

Nate:
Are you working with Excel or Microsoft Works?
Gene L

 

[Gene L.]

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

 

[nswhite]

Thanks for the help

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

 

[Gord Dibben]

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