ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Possible formula question (https://www.excelbanter.com/new-users-excel/196060-possible-formula-question.html)

nswhite

Possible formula question
 
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.

Possible formula question
 
Nate:
Are you working with Excel or Microsoft Works?
Gene L
"nswhite" wrote in message
...
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



nswhite

Possible formula question
 
I am working with Excel...I am hoping I am explaining it correctly...

"Gene L." wrote:

Nate:
Are you working with Excel or Microsoft Works?
Gene L
"nswhite" wrote in message
...
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




nswhite

Possible formula question
 
I am working with excel.

"Gene L." wrote:

Nate:
Are you working with Excel or Microsoft Works?
Gene L
"nswhite" wrote in message
...
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.

Possible formula question
 
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" wrote in message
...
I am working with excel.

"Gene L." wrote:

Nate:
Are you working with Excel or Microsoft Works?
Gene L
"nswhite" wrote in message
...
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





nswhite

Possible formula question
 
Thanks for the help

"Gene L." wrote:

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" wrote in message
...
I am working with excel.

"Gene L." wrote:

Nate:
Are you working with Excel or Microsoft Works?
Gene L
"nswhite" wrote in message
...
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





Gord Dibben

Possible formula question
 
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

On Wed, 23 Jul 2008 19:11:15 -0700, nswhite
wrote:

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




All times are GMT +1. The time now is 03:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com