Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
References to cells in other files
I have a number of excel files, each containing a project.
The files are named with consecutive numbers + project classification, ie. 326fi1257, 327mb112, 328fi121710 where the consecutive numbers are 326, 327 and 328. I also have a status file containing data from the excel files. I would like to let the status file look up certain data in the project files. The data to be looked up are placed in the same sheets and cells for each file. If possible I would like to use only the consecutive number as criteria for the references. Does anybody know weather it is possible? And how do I do it? If it is not possible, I could change new filenames to only include the consecutive number. Would that help? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
References to cells in other files
with code. I assume the files will be closed when you reference them. If
so, there is no worksheet function to support this. Indirect does not work when referencing closed workbooks. -- Regards, Tom Ogilvy "Daniel" wrote: I have a number of excel files, each containing a project. The files are named with consecutive numbers + project classification, ie. 326fi1257, 327mb112, 328fi121710 where the consecutive numbers are 326, 327 and 328. I also have a status file containing data from the excel files. I would like to let the status file look up certain data in the project files. The data to be looked up are placed in the same sheets and cells for each file. If possible I would like to use only the consecutive number as criteria for the references. Does anybody know weather it is possible? And how do I do it? If it is not possible, I could change new filenames to only include the consecutive number. Would that help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling Data, References and Flat Files | Excel Discussion (Misc queries) | |||
Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
Can a workbook be locked against change to cells containing references to other files? | Excel Worksheet Functions | |||
References to external XLS files | Excel Discussion (Misc queries) | |||
References to XLA files | Excel Programming |