I’m looking to select a range in an excel file to copy but depending on the files I don’t know how many rows are filled so I don’t know which range to select.
I thought about doing an If activity but I don’t know how to write that it must check if the cell is empty or not. And then if it’s not empty, append the row to a datable. Could you help me with that or show me another way ?
Same for the destination excel file, I’d like to detect the last filled row to paste starting from the next row.
Would love some help.