Extract data from workbook from desired range dynamically

I will have multiple excels like the ones attached and want to take the data from the position marked in green and delete everything marked in red, i could have used the range to read from the desired row but the problem is there’s no fix row from which the required data starts i.e,the row which is marked in green. i am attaching two screenshots of seperate files where the relevant data starts from different rows.

Hi @Debojyoti_chanda ,

Would you be so kind as to provide us with a sample template so that we can experiment with it?

Kind Regards,
Ashwin A.K

Hi @Debojyoti_chanda

You can try using Lookup Range Activity and give Reference No. as “the value to be searched” and give range in which “Reference No.” value is expected which will return you the address of the “Reference No.” cell which you will be used for the starting value in range for “Read Range” activity.