Thanks JBeaucaire, will keep this in mind for my future posts.
Mr. Shorty, I am the user writing the VBA, but also doing the labor of searching in the table to find the correct events. Originally, I have been typing search strings into our event software to find the correct events, but since I have several sheets to do this to, from each week of last year, and continuing, It's a tedious process, that, I thought could be sped up by exporting the table to be searched from our software to excel. That is what table B is. I thought, "Now that that table is in excel, I can do a vlookup, (or match) and easily find the correct events, but as you say, our software has that "search engine" type quality where you can type in "Yo Gabba" and everything with that comes up. I thought wildcards would do this in excel, but not so far. Also, to make the VBA process worth while, I'd need it to do this searching that I've been doing in our software with the VBA, not manually, otherwise it is no more efficient than what I am doing. Finally, I'm hoping to find a method to do that search on a R1C1 cell reference rather than actual words, because those words will change with each iteration of my loop. If you can think of any way to make this automated, great, but if you are stumped as I how to do that automation of the search in an R1C1 format, please let me know. I'll keep thinking on this, but for now, until the solution is found, I can keep doing the "search process manually. Again please let me know if you want to hang this up, or if you'd like to keep working on it. Thank you so much for all your help. I do appreciate it, I've learned much already from you, and hopefully, there is a solution out there! Thanks again!
musicman715