Escanaba
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
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
ASKER
My apologies. Instead of the tab named Ions I actually need the file itself named Ions. The tabs should remain the same.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you!
pls try
Regards
EE-Test-FileV1.xlsm