Coding works for single criteria, but how would you modify it for several criteria?

Hello, I've attempted to modify this code (See below) to check a cell in Worksheet "Execution Template" column #9 (I) for multiple criteria (a total of 5 different ones) then copy specific cells in that row;before going to the next cell. After copying the specific cells in the row that met the criteria in column #9 (I) they would be pasted in sequence into worksheet "TEST" (Gantt Chart). Unfortunately, I don't possess the skills to be successful at such an endeavor. My attempts have produced the code going through the complete loop for a single criteria then copying that row's specific cells before going to the next criteria and repeating the same process. This unfortunately has resulted in the pasting of the cells out of sequence. This makes it impossible to follow any work that belongs to the same JOB # on the Gantt Chart. I would appreciate any and all assistance on this issue. Thank you.

Please Login or Register  to view this content.

Thank you for responding. I may be missing something, but when I inserted the corrections, it only copies only the first match and does not continue looping through the column. Your assistance is greatly appreciated.

Thank you, but this is performing the same as the previous changes provided by protonLeah. It is quick and copies all of the cells perfectly, but only on the first match of the first criteria then it goes no further and copies no other matches. Sorry for being a pain.

Sorry, but it had the same results. It does not seem to go past the 1st criteria match. Thank you for trying.

Hummmm...I don't have your view on the Execution Template, so I've attached what I see. I've also copied the modified code that I did, and it copies all of the cells in the rows that meet the criteria in column
#9(I). Unfortunately, everything is out of sequence, and this doesn't work for tracking jobs. Please let me know what I can do to help you?

Please Login or Register  to view this content.