Recent content by mchanguion

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

Thank you so much for your post. I have macros written to automate the advanced filter operation and it works exactly as I needed it to. Thank you once again Marc

Hi yogia These are a few sample rows from a price list. I would do a search on say LC04 and am then looking for all matching rows in an output range. In this example, there would be 4 matching rows. Is there a way this can be solved by a macro? QI Q-BR02B LC02B Brand New Compatible Brother...

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...

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...