Find First/Last Data Row - need help

Hello. I’m working on 1st Excel Automation using StudioX. Currently I’m stuck at Find First/Last Data Row. I can’t seem to “append” or merge all data table of each worksheet to another new worksheet “CombinedData”. The result I got was each time, the automation overwrite the data table copied earlier from sheet 1 with data table from sheet 2 and so forth.

Anyone can help me here?

Wai Sie

Hello @wai_sie.yow

If you are trying to append the datatable to the excel, can you try with append range activity?
Append Range.

Thank you Rahul. :slight_smile: I can append the data table from each worksheet now.