VBA code to loop through autofilter

[klutz2009]

I have the following scenario:
Hypothetically Speaking,
Column A contains different types of fruits, and multiple entries of the same fruit.
I have column A autofiltered

What I need my macro to do is loop through that autofilter for each fruit, but not through every entry.
So I would like the loop to first select apple, and say 5 rows of apple data showed up I want to copy those rows to another worksheet.
The loop would then move on to the next type of fruit found in the autofilter, maybe a banana, copy it's rows and continue the process.

Thank you for all your help.
btw, this is my first post on this forum, I'm sorry If this is incorrect in anyway. I tried to go over the rules and look for answers relating to this topic, but I'm pressed on time and need assistance quickly.

 

[venkat1926]

if you are familiar with writing macro you can write following these steps

-column A has the name of fruits repeated more than once with column heading "fruits" at A1
-advance filter column A for unique values and park the unique values five rows below the data for e.g A25 to A30 with A25 is the column head "fruits"
then loop through A26 to A30 and autofilter every time,copying the filtered data in some other location and removing the autofilter. can you write a code. if there is a problem post back.

But if you just want to see only the same fruit together then just sort column A.