specific text

Hi, I m new to VBA and my problem is explained below with example i need to go from this : <tbody> rank name 1 jon 2 alex 3 william 4 josh 5 jamies 1 sarah 2 angela 3 haley 4 julie 5 sofia </tbody> In this table , i need to append a text which has no column name. 'A' has...

I have a workbook that has several sheets. In sheet PorS_LFT3 I have a cell that says "See Sheet SW_LFT3 regarding translation at Stripe [C]" In this sheet SW_LFT3 is a row that contains the text "Stripe [C]". I am continually adding new content to the sheet SW_LFT3 which when the data sort is...

Hey guys, I am trying to use conditional formatting to identify when a certain word appears in a list - "Road". I used "specific text/contains" in conditional formatting, to highlight those cells. However, it is also highlighting words like "Broad" (B-road). Example- in the below, I want...

I have searched everywhere on Google for the last 2 hours for a solution to no avail. Basically if 2 specific criteria are met, I need the value changed in another cell. My spreadsheet fluctuates daily and can have up to 50,000 rows. Column C is my model #. I am looking for a specific...

Hi All I'm looking for some help with a code to select a range based on its headed and footer in Column A I've got the below code written to find the text 'Bistro' and select the entire top row of the data, I'm looking to then scroll down to the next instance of the text 'Bistro' in column A...

I have the table below: <tbody> Date Product Price <tbody> 01/11/1903 </tbody> ezf 45 <tbody> 03/11/1903 </tbody> ezffez 10 <tbody> 07/11/1903 </tbody> ae 56 </tbody> and I am trying, using conditional formatting, to format a column if the cell above contains a...

Hello This should be easy but I can't seem to find how to do it. What I want to do is create a worksheet template so that when a list of addresses are pasted into it, all the Scottish postcodes will be highlighted. The postcode is already seperated from the address into its own column (K)...

I have a column of cells with narratives in them. I need to flag the ones that contain specific words. Currently, I am using =IF(COUNT(SEARCH("dog",M2)),"Y","") This works fine for catching everything with "dog," but it also "dogged" and "doggerel." How do I tweak the formula so that it...

Hi, I am stuck on what I think should be a very easy part of code but I cannot get it to go and it happens to be the last piece needed. I was hoping to find "Ticket Number" within column E. If the cell contains "Ticket Number" then resize the row height to 112.50 or 150 pixels and resize the...

The data I am working with contains blocks of cells in column C, with between 1-10 cells in them, that all have text in them. The blocks represent customer reviews. The last cell will always end with "(hide full review)". I want to write a function that will move through the column and...

Hello All, is there a way to find a specific word without counting in words that include it or are plurals of it. for example: I want to search for the word "site" however I do not want to include in my search the word "sites" or "opposite" help would be much appreciated!

Hi, I have been building a database for my small business for the book keeping I am currently using: Windows 7 64bit Microsoft Excel 2010 Basically I have a price column and a Income/Expense column. I want the currency value in the price column to be red text if the word in the Income/Expense...

Hi, I'm trying to use conditional formatting to colour cells within a column based on the text they contain. For example if A1 = A or B or C or D colour red, if A1 = E or F or G or H colour blue, if A1 = I or J or K or L colour green. I've tried some formulas, and while they are being...

Hi, Any help is appreciated on this query. I have a sentence in column C (Sheet1) and I need to search a specific text which is placed in Sheet2 Column A1 till A100. I am trying to check if Sheet1 Column C has the text from Sheet2 Column A and place that text in Sheet1 Column E. For...