Excel search macro

[mchanguion]

Hi All

I am trying to search a 4 column range (approx 5000 rows)for all matches on a specific value and for each match, I need all the fields in the row (4 fields) to be put into an output range. This output range should never return more than 20 matches. I need to return every matching row that is found, even if there are 2 identical matching rows.

Thanks in advance for any help.

Marc

 

[SkipVought]

Hi,

If you are running this code IN EXCEL, please post these answers, along with your original question, in Forum707.

So what code do you have so far? Please post.

Please post a sample of your data.

How is your input range defined?

How is the output range defined?

Skip,

_{When a wee mystic is on the loose..
It's a Small Medium at Large!}

 

[mchanguion]

Hi Skip

Thanks for responding. I have managed to solve this problem using the advanced filter command. Works really great.

Cheers

Marc