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
LVL 1
EscanabaAsked:
Who is Participating?
 
Rgonzo1971Connect With a Mentor Commented:
0
 
Rgonzo1971Commented:
Hi,

pls try

Regards
EE-Test-FileV1.xlsm
0
 
EscanabaAuthor Commented:
My apologies.  Instead of the tab named Ions I actually need the file itself named Ions.  The tabs should remain the same.
0
 
EscanabaAuthor Commented:
Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.