Please reference attached sample file. Using the existing code I am trying to figure out how to make a modification to add the following function:
Any rows that contain 000010, 000020, or 000165 are copied over to a new workbook with a tab named "Ions". Everything else in the code should run the same.
This code has been pieced together over time so any assistance would be greatly appreciated.
Note - I am not great at VB so please attach a revised sample file.