Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using Indirect Function to link to Other Files
Is this possible? I have a situation whereby I want to use one generic spreadsheet to create results for different data sets. The different data sets are contained in different files. I need to bring in each data set into the generic spreadsheet and then save it as a specific spreadsheet for that data set. I thought a way of doing this might be bring in the data by means of a straightforward cell reference eg formula = '[dataset1!]SHEET1'!A1. To make things easier I would like to use the INDIRECT function instead of the actual file name so that I can change all the cells by changing one. Is this possible? Thanks tt -- Timmy Mac1 ------------------------------------------------------------------------ Timmy Mac1's Profile: http://www.excelforum.com/member.php...o&userid=15188 View this thread: http://www.excelforum.com/showthread...hreadid=390508 |
#2
|
|||
|
|||
INDIRECT will only work with open files.
-- HTH RP (remove nothere from the email address if mailing direct) "Timmy Mac1" wrote in message ... Is this possible? I have a situation whereby I want to use one generic spreadsheet to create results for different data sets. The different data sets are contained in different files. I need to bring in each data set into the generic spreadsheet and then save it as a specific spreadsheet for that data set. I thought a way of doing this might be bring in the data by means of a straightforward cell reference eg formula = '[dataset1!]SHEET1'!A1. To make things easier I would like to use the INDIRECT function instead of the actual file name so that I can change all the cells by changing one. Is this possible? Thanks tt -- Timmy Mac1 ------------------------------------------------------------------------ Timmy Mac1's Profile: http://www.excelforum.com/member.php...o&userid=15188 View this thread: http://www.excelforum.com/showthread...hreadid=390508 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
how do i link data from multiple standardized excel files | Excel Discussion (Misc queries) | |||
offset and indirect function | Excel Worksheet Functions | |||
indirect worksheet function in excel | Excel Worksheet Functions | |||
carrying a hyper link when using the vlookup function | Excel Worksheet Functions |