I'm trying to do something that looks up a value in a file based on a source directory as defined in a cell. So I have in cell M5 in this case a directory, like "C:\Users\111222333\Documents\Source", and in another cell I want to display a value in a cell in the file C:\Users\111222333\Documents\Source\data.xls.
I can write it out in full, adding Sheet!A1 for example. The problem is that I want to be able to change the source directory in M5. What would the syntax be for that?
Thanks
I can write it out in full, adding Sheet!A1 for example. The problem is that I want to be able to change the source directory in M5. What would the syntax be for that?
Thanks