Hi,
I have attached an example sheet with input and output for reference.
I have been scouring the internet but can't seem to figure out how write the right VBA to:
1. Search for the first instance of the phrase "My name is" and copy that whole cell and paste it in a cell that is in the same row as the first number.
2. Similarly, search for "This survey took place" and copy the following date (the dates differ in length sometimes), and paste that in a cell that is in the same row as the first number.
For the first part, this is what I have (incorrectly) come up with so far:
Please Login or Register to view this content.
Any help would be greatly appreciated! Thanks!
Example Input and Output.xlsx
Bookmarks