Forum Discussion
Helper IImport several source files in several sheets in Excel
Easier than you might think! You can leave the rows of content as is, then right click on your query, and select "Reference".
Now you have a new query that references those content rows. Now you can right click on the File ID value that you'd like to load to sheet1, and select "Equals". Now your reference query has just the table you want to load. You can again right click on the original query and make another reference query, and filter to the Flie ID for the second table you want to load.
If you need it to be dynamic, you can instead make a blank query like:= QueryName{0}
This will give you just the first row. QueryName{1} will give you the second row, and so on.
--Nate
Easier than you might think! You can leave the rows of content as is, then right click on your query, and select "Reference".
Now you have a new query that references those content rows. Now you can right click on the File ID value that you'd like to load to sheet1, and select "Equals". Now your reference query has just the table you want to load. You can again right click on the original query and make another reference query, and filter to the Flie ID for the second table you want to load.
If you need it to be dynamic, you can instead make a blank query like:
= QueryName{0}
This will give you just the first row. QueryName{1} will give you the second row, and so on.
--Nate
Manuel123Dear Nate,
thank you very much, that was exactly what I was looking for.
BR
Manuel