Avatar of Escanaba
Escanaba
Flag for United States of America

asked on 

Excel 2007 VB Code Adjust to Combine Rows

Hello,

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.

Thank you!
EE-Test-File.xlsm
VB ScriptMicrosoft OfficeMicrosoft Excel

Avatar of undefined
Last Comment
Escanaba

8/22/2022 - Mon