Hi,

I have:

Workbook called "Fruits".
= It contains sheets "s1" and "s2".
= "s1" contains 8,000 rows of data.
= "s1" contains the columns "Id", "Description", "Color", etc ...

I would like to:

= Have a button in called "Find Fruits" in "s2".

= This button should take the (search) criteria from
cell "b3" in "s2".

= Where "b3" may contain the text. For example, "gre".

= So when the button is clicked the VBA code would find all
the rows in "s1" where the "Color" contains the text "gre".

= An example row would be 896, Pear, Green, ...

= Note that this row is selected because "gre" is contained
in "Green". (not case sensitive)

= So "ree" would also work.

= So as long as the matched item *contains* the required
text, it is enough.

= All the rows in "s1" that match should be copied and
pasted into "s2" starting at cell d6.

Can you please give me the VBA code for the "Find Fruits" button?


Thanks,
Luther


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/