Selecting Groups of Similar Data

I have ~1,000 rows of data utilizing columns A:C. The data is "grouped" by data that is in column C. Layout is as follows for example

Row01.....Column A......Column B.......Column C
Row02.....some data.....some data.....apples
Row03.....some data.....some data.....apples
Row04.....some data.....some data.....apples
Row05.....some data.....some data.....apples
Row06.....some data.....some data.....oranges
Row07.....some data.....some data.....oranges
Row08.....some data.....some data.....oranges
Row09.....some data.....some data.....oranges
Row10.....some data.....some data.....pears
Row11.....some data.....some data.....pears
Row12.....some data.....some data.....pears

I have been trying to come up with some code that will "select" groups of data and then perform an action on those cells.

As an example

Please Login or Register  to view this content.

Thanks in advance for any suggestions.

Hello maacmaac,

Are all the groups always together as in your example? All apples together, etc.

It looks like you're actually trying to grab all the rows of data that match the fruit in column C. Have you ever used an AutoFilter? That's what it does. And you can do actions on the filtered data, too.

Further, with an autofilter, it won't matter that all pears/apples/oranges aren't altogether in the data set. An autofilter hides all rows that don't fit the criteria and you can grab the visible data to do stuff.

Please Login or Register  to view this content.

Here's an example of a loop that goes through an array of fruits.

Please Login or Register  to view this content.

=======
LAstly, notice my code isn't "selecting" cells before copying or whatever else you're going to do to it? Get in the habit of NOT selecting, it's 90% of the time a wasted step and unnecessary.

As an example, a way to select each group could be done this way:

Please Login or Register  to view this content.

Rather than selecting that range, you could obviously perform some other code to it or to adjacent ranges.

Use AutoFilter on column C, hen perfor the action on the filtered range.

This can be automated with VBA - use the macro Recorder to start or there's lots of autofilter code on the forum, I've posted seversl examples

Wow!!! Never expected so many repsonses to one question. Thank you, thank you, thank you. Leith...to your question, the data is always grouped together. Completed testing of both codes presented and both work as expected. Plus a lot of good information in other threads about autofilter.