Hi,
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.
explaining:
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
To find out how many rows of data you have insert the following formula above or below your data @count(from..to)
so if the data is on Sheet A and starts on row 5 and ends on row 3987 and starts in column A then the formula would be @count(A:A5..A:A3987)
To extract the 5% of the data exactly the same every time I will need to know the criteria which determines how you are going to sort the data. If you can give a small set of data as an example that would help.
Please also let us know how you want the data in the second sheet. Do you want it as formulae or as values?
Hope to hear from you soon.