Excel Macro Help

[Desu Nota from Columbus]

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?

 

[Weaver]

Your best bet is to apply a filter so that only the desired rows are visible, then use specialcells(xlcelltypevisible) to select, copy and paste only these.

You could do some of it using the macro recorder, especially the filter part, then maybe create a loop that looks at each criteria in turn.

HTH

 

[Desu Nota from Columbus]

sorry for the very belated response, but I did exactly what you recommended and got it to work. Thanks

 

[Weaver]

I'm happy to hear that worked out for you. Thanks for the feedback.