Hi, in my system, when i extract report from system, the layout is rather hard to see. Hence i am trying to do a Query for my staff so that can transform it to a user friendly format.
However, when i click use the "Get Data from Table/Range", it auto transform my Raw Report to a table.
I discover that i can only get from Worksheet thru the "From Excel Workbook", i do not want to use this as the Path will be invalid if i email my staff the excel.

Is it possible to get Data from the same workbook without transforming it to a Table?