I'm trying to link some different sheets that all are in the same folder, but I want to avoid absolute file references.
The quotes will always be in the same folder for the same project so the folder structure would e.g. be as be below:
1.png
File structure would be similar to below
2.png
The summary file will extract data from the quotes and and present them in a a table. I want the summary file to be a template where the only thing a person needs to enter is the filename and the an indirect formula pulls out the data. That is easy enough, but it requires the quotes to be open. If I close the qoutes I get #REF. Open the quote and the value is shown again. How do I avoid that (can't have all the files open all the time)?
/Møller
Bookmarks