first excuse my english it isn't so perfect...
well, I have a file with more o less 4000(this change monthy) rows of data
ok, I need a macro or a script that tell me how many rows with data there are, then extract the 5 percent of this data to another worksheet.
if I have 4000 rows with data in the file I need to extract the 5% of this data, (4000/100)*5, to another worksheet. but it have to be "sorter", if I run the macro/script again it can't give me the same information...
I don't know if I was clear, but try to understand, please, my original language is spanish, so excuse my english again, thanks