How to loop a process

Hi, I did a process on excel. How do i loop the process multiple time and stop it when Im done??

U can use For each Row for looping excel row wise

For this u need to read that data in sheet using read range and then u can loop that datatable

@SamanthaGoh

If you want to loop inside the Excel data and do some activities for each row then use For Each

But if you wan to run the entire process for multiple times then try as below

image

Counter will use to run how many times

Using that you can define IF condition
Mark as solution if this helps

Hi @SamanthaGoh,

You can loop through each row of your Excel spreadsheet with a For Each Row as @ImPratham45 mentioned. Use a Read Range to get the value of your spreadsheet, and use this variable in the For Each Row. It will loop through all of the data rows and exit once it has completed.