Dynamic Input where to Start Data Import?

[CDGover]

Is there a way to specify where to start the data import for a group of spreadsheets. Example: Instead of saying "start data import on line 14" I want to say "start data import where [field] = 'value'".

[ivoller · Accepted solution]

Not really.

You can pull in the data and then locate the appropriate starting point to produce a new table with only the required data. Alternatively you could set up the range you are interested in the excel by using a formula based named range and then only importing that range.

[CDGover]

Thanks you for the quick response!