I would like to do a loop equal to the number of rows that is not empty in my workbook.
What the code does is it looks for a value in the second column of the workbook and if it exits, it copies the whole row and pastes it onto another workbook, row by row.
My problem is that my original workbook may be anything from 25 to 2000 rows long but I do not want my loop to execute 2000 times each time it runs.
How can I count the number of nonempty rows and only let my loop execute that number of times.
This is my first post. Any help would be hugely appreciated