keyword

OK, so here is what I am looking for. Is there a way to write a VBA code that will search real estate websites for a "keyword" in the property description and if it finds said keyword return the MLS# associated with said property. Why I ask is there are some real estate websites that allow...

Hi, I am looking for excel formula i.e matches keyword in entire column. for example in "Column A" i have 1000 list of details about products. Now i want to find who are using product "Red", "Green", "Orange"......etc Column "A" ABC Red Green XYZ Orange GHI -- -- -- Please get me formula for...

Hi everybody, How it is possible in Power Query to partially search if a value in one dataset exists in the second one. I want to replace this approach: if Text.Contains([Column in 2nd Dataset], "Keyword 1") or Text.Contains([Column in 2nd Dataset], "Keyword 2") or...

Frnds, I need a Macro to delete rows in excel to cell with specific keyword "Job Number" in excel and next find if cell exactly next row is blank, if yes then delete this row with blank cell and above two. NB, If its a blank records then it will only be single blank row below "Job No" as...

Hi! I would like to have a macro that I can "toggle" on and off that will highlight all cells that have a user-inputted word. For instance, if the user inputs Available", then I would like all the cells that contain the word "Available" to highlight yellow. If I run the macro again, I would...

I'm trying to make a list of keywords so every time I type a keyword or phrase into one cell, it will autofill into another "summary" worksheet so I can find all the keywords I've used and where they show up/how many times they've been used so I can see trends. Using "Concatenate" doesn't work...

Hello!What I have:At the moment the inserted filter that I can put on a column has a list of things in the column, and by choosing an option I can filter for that *exact* option.What I want:I have a column of cells that contain various words. Examples: "tree", "tree fish", "tree apple smile"...

Hello, I need to sum the amount that appears in the column C every time that on the column B appears "tech" or "error", however there are lines on the column B that appears Tech and Error in the same cell and I dont want to sum the amounts of column C twice. How can I do it, please? <tbody>...

I have searched the forum but I can't find anything that quite matches this. This is for a healthy eating project. Students record their meals in a daily diary. This is random unformatted text in a single cell (B1, B2 etc). There is a keyword list of healthy foods, each item being in a...

Hi everyone, I'm relatively new to VBA and I am really struggling with the following task.. I am creating a huge excel file, and need to find out the names, from one row <tbody> James LEE went to mall today James, Lee Rental payment for Lee James James, Lee Orders for JAMES LEE James, Lee...

Hello all, (Very first post and as mentioned extremely new to VBA - which programmers tell me will melt my brain ;) ) I have some code already that works to open a workbook and search for a keyword and copy the cells next to that word. Now I have a need to search designated workbooks for a...

I've made a spreadsheet (database?) of my digital movie collection. I've got about 750 files over six different portable hard drives. Some of those are duplicates, as happens over usage and multiple people in my family using them. The spreadsheet is done in Excel 2010, and it consists of...

I understand dynamic range to be a name for a range that Excel would recognize ("Inbound" for example might tell Excel to reference A1:A30) Is there a way however, to get Excel to dynamically change the range by using keywords? For example, without manually selecting A1:A30, could I get Excel...

hello, i need a macro that i can click a "search" button, an input box pops up asking what id like to search, then searches through all the sheets in the workbook. Id like it to operate almost exactly like the (ctrl+f) search function, with the "find next" option. If there is a way i can bring...

Hello, I am in need of a forumula. I am trying to extract one word before a keyword, one word after a keyword, 2 words before a keyword, and 2 words after a keyword. For example: The keyword is blue: birds are blue today - 1 word before=are; 1 word after=today; 2 words before=birds...

This formula will search the B cell for a word and post an indicator if it contains the keyword. =IF(ISNUMBER(SEARCH("citations",B170)),"1", "") My obstacle is I need four of these that each search for 3-4 different keywords. I've tried things like: =IF(ISNUMBER(OR(SEARCH("citations",B170))...

Hi All, I am new to this forum, but just had to post as I am struggling having spent many hours searching, I cannot find a suitable answer for my needs so hope I have explained enough below. Situation: I have a document containing many many words, like a specification or book, for which I...

I have to categorise a large volume of data in order to analyse it. I need to categorise it based on the text in the offer column. Is there a way of doing this based on keywords? Here is some example data with an explanation of what I’d like to be able to do below: <TABLE style="MARGIN: auto...

Hi thanks for reading my post. I have written a UDF (well borrowed it from somewhere, probably this site) that extracts alpha strings longer than 3 letters long and discards numbers and other characters. For example from: EUR 010210-280210 CAR RENTAL it will return: EUR,CAR,RENTAL However...

Is there a Keyword (such as "Me" or "Parent" etc.) that I could use to Return the Name Property of a Control from within that Control's Event Code. For example: Private Sub cboComboBox1_Change() Dim strControlNameCurrent As String Dim strControlNameOther As String 'With...