I've looked throughout the forums over the last few hours and haven't found a solution, so I thought I would post and see if someone could help.
I have a database of upwards of 10000 rows. I would like a VBA macro that will do the following...
1. Open a text box to have the user enter a keyword.
2. Search for all instances of that text string in column E of the active worksheet.
3. If the text string is found, copy that keyword to the same row in column W. If there is already text in column W it is to be overwritten.
I don't think it should be too difficult, but it is giving me fits.
Thanks in advance.
Mike
Bookmarks