Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conoslidate from different files with same format
Dear all
i am working with Excel XP edition and in a local network having one public folder. In this folder i am saving 14 files which all of them has the same format. I am trying to consolidate some of their sheets. I though to use the vlook up function including the indirect formula but indirect will not work if the 14 files are open. if any of the files are close i have a REF. Does anyone have any good ideas how can i work in one workbook by pooling data from the 14 files without to have all of them open? The challenge here is that the next month i will create a new folder with another 14 files, so i have to change all the links. Any good ideas? Do i have to use a VB code to solve the problem? Thanks in advance, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CSV files - auto format | Excel Discussion (Misc queries) | |||
Number format on existing files | Excel Discussion (Misc queries) | |||
How do I convert .qpw files to excel format? | New Users to Excel | |||
Saving txt files and date format changes | Excel Programming | |||
Autosave of xls files in csv format with macro | Excel Programming |