Directional Row Search Macro for Multiple Values

[swilkinson1]

I am using a Directional Search Macro (NAM button on ClientFilter sheet) to copy data from one sheet to another IF the criteria in a certain column is matched. In general for this example, IF the value in Column C = NAM, then copy the row to NAMFilter.

What I need is to edit the macro contained in the attached worksheet, NAMFilter, to include NAO and NAL in the search as well as NAM. The search and copy for NAM is working fine but I need to include all three acronyms, NAO, NAO and NAM.

They should be copied to the NAMFilter sheet accordingly.

Please let me know if you need more information.

As always, I appreciate the assist!

[protonLeah]

Why copy NAO & NAL to the same sheet?

[swilkinson1]

NAL, NAO and NAM are subgroups. I am filtering the data further but have to include all 3 groups (charts, graphs, etc). The totals I am working with come from all 3.

[protonLeah]

Please Login or Register  to view this content.

[swilkinson1]

Genius! I love this forum! Thank you.

What is your secret to get the macro to run 'quietly' in the background without seeing the physical search? At first I did not think it was running.

[protonLeah]

Application.ScreenUpdating = False

[swilkinson1]

Thanks again!