Excel: Flexible data output

I want to get the data from xx number of fields in my excel sheet and move it to another?

I have a variable in rpa express with a number… could be “100” -> then I need the process to mark and copy paste (get_data) from the 100 first files in the sheet (from A1 - A100).

How do I do that?

Use a counter and a while loop. And put the number of rows (e.g. 100) into a variable.
While(variable >counter)
Get cell from excel (or get row, whatever you need) and
save into list or table variable
Set active cell cell below
Counter=counter+1

1 Like

That should work… thanks alot.