I have the following code to search for "no" in column D of sheet 1 and automatically transfer data to sheet 2. But this is based on only one criterion ("no "criterion). I need to add another criterion to the code to make sure that all "no"s and "no-rq"s are automatically transferred to the new sheet. How can I modify the existing code to incluse the second condition? Thanks.
Please Login or Register to view this content.
Bookmarks