Macro to search for specific words in proximity to each other?

Does this help?

Please Login or Register  to view this content.

That's really great thanks, it does exactly what I wanted it to.

However is there a way to expand on it?

For example; I might have lots of different types of fruit in column A. Is there a way to instruct the macro to only identify certain pairings. So I would have lots of orders with different selections of fruit, but it would only filter orders that specifically have both an apple & pear?

Try:

Please Login or Register  to view this content.

Hi, yes that seems to be working. Thank you very much

However, is there a way to tweak the code to include another column (quantity) to copy over. eg:

ref	fruit	qty	ref	fruit	qty
001	apple	1	001	apple & pear	1
001	pear	1	004	apple & pear	2
002	apple	1
003	apple	1
004	apple	2
004	pear	2
005	pear	1

Try:

Please Login or Register  to view this content.

That's amazing thank you very much

You're welcome. Glad to help out and thanks for the feedback.