I am doing a query from a folder with many Excel files which all have the same structure. I want to reference a certain row which is always in the same place (row no. 5) in the same sheet in all of the excel files.
How can I do that? There is no reference point like a certain word that I could filter for, I just need row no. 5. The row sometimes is empty, partially filled or completely filled in. I need it in all 3 states.
Can anyone help me?
Thanks!