| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
getting data from a range in another workbook (excel 2003)
i'm not sure of the command to get a named range for a workbook in the same
folder as the workbook i'm using |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
getting data from a range in another workbook (excel 2003)
Something like:
=SUM('C:\Documents and Settings\Owner\My Documents\Book2.xls'!alpha) Where alpha is a Named Range -- Gary''s Student - gsnu200908 "Mainer" wrote: i'm not sure of the command to get a named range for a workbook in the same folder as the workbook i'm using |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
getting data from a range in another workbook (excel 2003)
can i just put the workbook name if the workbook is in the same folder?
"Gary''s Student" wrote: Something like: =SUM('C:\Documents and Settings\Owner\My Documents\Book2.xls'!alpha) Where alpha is a Named Range -- Gary''s Student - gsnu200908 "Mainer" wrote: i'm not sure of the command to get a named range for a workbook in the same folder as the workbook i'm using |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
getting data from a range in another workbook (excel 2003)
Try it and see.
Post back your results -- Gary''s Student - gsnu200908 "Mainer" wrote: can i just put the workbook name if the workbook is in the same folder? "Gary''s Student" wrote: Something like: =SUM('C:\Documents and Settings\Owner\My Documents\Book2.xls'!alpha) Where alpha is a Named Range -- Gary''s Student - gsnu200908 "Mainer" wrote: i'm not sure of the command to get a named range for a workbook in the same folder as the workbook i'm using |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying data from one cell to another in a workbook in Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel 2003: Copy rows from one workbook into another without losinginterleaved data | New Users to Excel | |||
| Excel 2003 - Charts - "Data Range" and Date/Time data on X-Axis | Charts and Charting in Excel | |||
| Excel use another Workbook for data validation range. | Excel Discussion (Misc queries) | |||
| Excel 2003 This Workbook contains queries to external data | Excel Discussion (Misc queries) | |||
Linear Mode
