I have a workbook that has two sheets. On the first sheet is a list of approximately 30 text strings (i.e.: customer is not happy, not negotiable, no one cares, etc). The second sheet has multiple columns from A:EF and approximately 785 rows. The data I am searching for is in column...
I want to select all rows that has the string "Apples" in a cell in column B. I want to copy and paste these cells into a new worksheet.
I also want to be able to search for "Oranges" and "Passionfruit" etc.
Is there a way to do this?
I am very stuck. Here's what I am trying to do:
- Sheet1 Cell D4 has a drop down list containing names.
- I need a macro to search through Sheet2 column D for that name
- IF found, then take some action (I have written code for this)
- ELSE (ie. if not found) do nothing.
I am a VBA...