No we will solve the Problem with 2 macros
Bcoz we will break the process into 2 pieces one macro to count total no. of rows
& second macro for copy paste to csv
It will be easier to understand & easy to solve