joshneedscoffee
New Member
- Joined
- Nov 15, 2016
- Messages
- 1
Hello guys 
I have a master spreadsheet with summaries, stats, and observations on about a thousand experiment results and ongoing. Each row corresponds to a unique experiment ID#. The instrument I use also generates a csv with the same name as the experiment ID#.
I have tried several other options, but the following formula gets me closest:
It creates a dialog box asking me to locate the file. I don't want to locate the file every single time, I just want it to import the text values in cell B11 from the csv at that filepath from that sheet automatically. Previous solutions I have found here and elsewhere were from people wanting a dialog box prompt to open to locate their files.
Hopefully, I am missing something simple here one of you guys could point out.
Additionally, I am using a column with the data source filepath (\\companyname.com\storage\) and concatenating with the experiment ID# in the master spreadsheet (1010015216-results.csv) to generate the full csv source filepath I use in my formula.
I have a master spreadsheet with summaries, stats, and observations on about a thousand experiment results and ongoing. Each row corresponds to a unique experiment ID#. The instrument I use also generates a csv with the same name as the experiment ID#.
I have tried several other options, but the following formula gets me closest:
=(\\companyname.com\storage\[1010015216-results.csv]1010015216-results!B11)
It creates a dialog box asking me to locate the file. I don't want to locate the file every single time, I just want it to import the text values in cell B11 from the csv at that filepath from that sheet automatically. Previous solutions I have found here and elsewhere were from people wanting a dialog box prompt to open to locate their files.
Hopefully, I am missing something simple here one of you guys could point out.
Additionally, I am using a column with the data source filepath (\\companyname.com\storage\) and concatenating with the experiment ID# in the master spreadsheet (1010015216-results.csv) to generate the full csv source filepath I use in my formula.
