I am trying to concatenate an “import” formula so that data from several csv files can be correlated in one master file. I derived the formula by manually copying data from one sheet to the other. I then replaced the specific file reference with a cell reference, A1. A1 in the master sheet contains the name of the required file in cell A1.
The formula I’m using is ;
=CONCATENATE("=‘file:///home/rob/CSV Files/IG.", A1, ".csv’#$‘IG.", A1, "’").F3
But when I run this a 501 error is returned. I’m hoping someone can point out my mistake. Thanks!