visible cells

[new girl]

this is what my sheet looks like:

[image: http://bray.homeip.net/shay/screen1.jpg]



then i do this:

[image: http://bray.homeip.net/shay/screen2.jpg]


then i sort by the total descending:

[image: http://bray.homeip.net/shay/screen3.jpg]


then i need to pull out the top 25 results and move them to anothe
sheet:



[image: http://bray.homeip.net/shay/screen4.jpg]


the problem i am having is i do not know how to tell the macro to pul
out only the 1st 25 results. i never have 2 spreadsheets with the sam
sales information

 

[Frank Kabel]

Hi
try to explain your issue in plain text. Most people won't open 4
attachments