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!
Bookmarks