search keywords

Hello, I am very new to VBA and my head is spinning trying to figure out what to do. Any help on my question is very much appreciated! I have a sheet of customer info and am just looking to run a macro that searches for specific keywords in a couple of columns (an OR situation), and if any are...

Hello, I have some data in rows but they are not organized in the proper columns. I'd like to search the row for keywords, parse and extract the information in the cell to build a new table. Here's an example of the raw data: <tbody> <tbody> <tbody> <tbody> <tbody> A B C 1 $2.50...

Sheet2 contains more than 200000 rows (with unique strings in Column A and B). I would like to search 1 to 3 keywords from Sheet1, Keywords in B1,B2,B3 and get all matching cells from Column A from Sheet2 to Sheet1, starting with Cells A5. For Column B (B5 onwards), I am using vlookup to get...

Hello, I have the following Excel data and I would like to return the repeated values found when the user searches for keywords. It can be a formula and/or VBA code. To be considered: 1. Column A and B have fixed values. 2. Column C and D are the keywords that the user will enter (not...

Hello guys, I have this challenge that i am trying to tackle. <tbody> tele tele Tele bla bla fa, bla,tele, ka, ha, tele la, ra, tele, tele tele bla </tbody> i want a command that.. 1- looks for B1 cell inside A1:A8 range 2- If it finds a match return whatever...

Hi folks, I have a problem that has me stumped sideways til next Thursday. Maybe I am just fried because it's Friday and I have been struggling with this all week, or maybe I am still not seeing the bigger picture. This is why I come to ask help from the experts. Problem: Searching a...