Excel VB To Copy Text In String and Paste In 2nd Worksheet
Posted on 2013-01-09
Can someone assist in developing a VB macro that will do the following:
1. In Sheet1, column AG, there is a string of text and numbers. The code looks at the string, and copys the text that appears between: 'Context ' & '@' symbol. Please note there is a space that appears after 'Context' that should not be included in the copy. The data being copied on average is 7 characters long.
2. Paste that data in Sheet2, column A