Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
links to several xls with same named ranges
Mike,
Not sure I understand what you are doing. But if you are trying to copy information from a list of workbooks to a master workbook - my approach is to have a list of the workbooks in my master workbook and use a For... Next loop to open each workbook and copy ranges to the master. Careful coding can make this run relatively fast. Others use a technique to search for the files and open each in turn. Much depends on how the files are named and where they are located. One of my workbooks pulls files from different folders and copies data to the master. Again using a list in the master. steve "Mike" wrote in message ... I have a template workbook that uses 20 named ranges to get picked up my a master workbook. Complexity is that there are 100+ project workbooks to be compiled. All are based on same template but require different filenames (corresponding to project names. The cell addresses and named ranges are the same in every template workbook. What is a good approach for this (other than Access)? TIA Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
named ranges? | Excel Worksheet Functions | |||
Named Ranges | Excel Worksheet Functions | |||
Named Ranges | Excel Worksheet Functions | |||
Max # of named ranges | Excel Discussion (Misc queries) | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) |