Get dynamic range and paste it to another excel/

[HareeshMR (Hareesh Madasi)]

Useful link here

Read range with unknown size

@Joeri_Rethy, If you have columns more than 2, i.e., your excel containing columns from A to Z or even more, you can achieve this by using two read range activities as in the screenshot below. [image] You have to mention the range as in the screenshot.

This will work, use two read range activities and get the entire data table in first activity and required in second…

dt .rows.count will give you the dynamic range @Slavich