Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking spreadsheet
Hi - I have seen several similar strings but cannot see an answer
I have a collection spreadsheet to pick up data from a growing number of spreadsheets. I can use the inderect function which allows the user to type in the new spreadsheet name and so pick up the data. But this only works when the target spreadshet is open. How do i replicate the link spreadsheet function but allowing users to simply enter the new spreadsheet name? Target spreadsheets all stored in the same folder & target data in same cells etc Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking 2 spreadsheet using data from the last row of spreadsheet | Excel Discussion (Misc queries) | |||
Linking 2 spreadsheet using data from 1st spreadsheet | Excel Discussion (Misc queries) | |||
Linking spreadsheet | Excel Worksheet Functions | |||
Linking between sheets on same spreadsheet | Excel Discussion (Misc queries) | |||
Spreadsheet Linking to Calendar | Excel Discussion (Misc queries) |