To use a single excel sheet as two different data tables

[loginerror (Maciej Kuźmicz)]

@chintham
Normally when you put a double quote “” as your range it will only take the non-empty fields.

Please see this thread for more reference:

Trying to read a single excel sheet as two different data tables

My excel sheet has 6 columns and I wish to read only one column as one data table and all the remaining rows as another data table. I don’t have any idea how to do that. Can you please give me a procedure how to do that. Thanks in advance.