SAMPLE FILE: CopyXRows.xls
"I have a filtered set of data, I only want to copy the first 10 rows of the remaining visible data to another sheet. How can I do that?"
From the MrExcel.com website comes this alternate technique that does the same thing without "looping".
Nothing says "thanks" like a steak dinner!
Filtering Tricks >