how to read excel by skipping couple of initial line’s
At read-range you can choose which range to select
@mwerner but range keeps changing
Use Lookup Range to search first line(“Resource requirement - Sales” in your case)
Then you can set range for Read Range
@Dongjin_Lee AS i have checked headers are showing up in 3 rows and some 1 row
ex: proposed associate name in 3 rows and Role in 1 row
I think you can’t do directly read that datatable as you want.
You have to modify datatable after reading.
@Dongjin_Lee how can i modify the datatable