Astronaut01
New Member
- Joined
- Jan 26, 2022
- Messages
- 18
- Office Version
- 2016
- Platform
- Windows
Hello excel vba experts
Im quite new to excel vba and need to create a vba tool that can:
1. Search for all data value/s that has the "RTN000..." in column F. Some cells in column F has mulitple "RTNs..." and symbols and words.
2. Once found, it should copy that specific "RTN" together with all the row data, to a sheet i named Output.
Been trying to see if a use of wildcard would work but not sure how. Many thanks in advance for all your solutions.
Im quite new to excel vba and need to create a vba tool that can:
1. Search for all data value/s that has the "RTN000..." in column F. Some cells in column F has mulitple "RTNs..." and symbols and words.
2. Once found, it should copy that specific "RTN" together with all the row data, to a sheet i named Output.
Been trying to see if a use of wildcard would work but not sure how. Many thanks in advance for all your solutions.