| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting data from hyperlinked spreadsheets
I have a master spreadsheet with hyperlinks to around 2,000 other
spreadsheets. All of the hyperlinks are held in the same column. All of the other spreadsheets are of a standard format. There are 8 cells on each of these spreadsheets that contain data that I want to collate in the master spreadsheet. How do I do this without resorting to manually linking to all 2,000 sheets? -- Thanks in advance of your replies. Your help much appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting Hyperlinked data | Excel Worksheet Functions | |||
| Extracting or Referencing named cells in multiple spreadsheets | Excel Discussion (Misc queries) | |||
| Extracting Data for .Txt Files By Unique Field Data | Excel Discussion (Misc queries) | |||
| Formulae extracting data from other spreadsheets | Excel Discussion (Misc queries) | |||
| Extracting Data | Excel Discussion (Misc queries) | |||
Threaded Mode
