Excel 2007 VB Code Adjust to Combine Rows

Escanaba
Escanaba used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016

Commented:
Hi,

pls try

Regards
EE-Test-FileV1.xlsm
EscanabaManager - HR Analytics

Author

Commented:
My apologies.  Instead of the tab named Ions I actually need the file itself named Ions.  The tabs should remain the same.
Top Expert 2016
Commented:
EscanabaManager - HR Analytics

Author

Commented:
Thank you!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial