| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula question | Excel Discussion (Misc queries) | |||
| Formula Question | Excel Discussion (Misc queries) | |||
| What IF - formula question | Excel Worksheet Functions | |||
| question on formula | Excel Discussion (Misc queries) | |||
| Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
Linear Mode
