Add looped into datatable, find lastrow, clear content

[Dominic]

Hi @Serran_Neru,

1. Read this Excel using Read Range activity and store it in a datatable variable.And loop it using for each row activity then access invoice number as follow row(“Invoice Number”) this returns current row’s invoice number
2. Start your operation of scraping data here and save it in another sheet (Output) as you said. My suggestion would be add it in a datatable using Add Data Row activity with pre-build datatable with headers such as Piece ID, Pickup Date…,etc
3. Process Continues until you have invoice number
4. Finally write it in the same sheet using Write Range Activity by specifying the range

Hope it helps you ! Sorry If I have confused you. Let me know if you have any concerns.

Thanks and Regards,
Dominic