Loop through rows (Dynamic number)

Hi All,

I have created the code below (Spreadsheet Attached) which works for the first row but I want the code to loop through each row. I know there is a way aroud this by using count and then the rows will increment by 1 every time it loops through the code. Unfortunately I do not know how to do this.

P.s. i do not want to specify how many rows and the number of rows is dynamic.

Any ideas? Any help would be greatly appreciated.

Please Login or Register  to view this content.

Kind regards,

James Elwell

Hi James

Try this

Please Login or Register  to view this content.

You're welcome...glad I could help. Thanks for the Rep.