I am looking to make a Macro in VBA that when run:
I think an array for the words would work best as The list of words might change
the sheet always has the info in the same column so its always column b that has the words in
I am able to code the macro if Colum b only contained the word. but 99% of the time it's only part of the string of text
if anyone could help that would be amazing
I am not very savvy with VBA,
I found pieces that allowed me to create a new sheet after the original and then name it something, then I found out how to select words from B and make it select the row and move it to the other sheet.
its mainly setting up the array and then having it search out specific words in a line of text in each cell
- creates a new sheet called "results" after the first sheet (to the right)
- on the original sheet search Colum B for if any of an array of words is present in a cell
- if it is to select the row and move it to the sheet called results
- delete the empty space from the moved row
I think an array for the words would work best as The list of words might change
the sheet always has the info in the same column so its always column b that has the words in
I am able to code the macro if Colum b only contained the word. but 99% of the time it's only part of the string of text
if anyone could help that would be amazing
I am not very savvy with VBA,
I found pieces that allowed me to create a new sheet after the original and then name it something, then I found out how to select words from B and make it select the row and move it to the other sheet.
its mainly setting up the array and then having it search out specific words in a line of text in each cell