search string

Hello All, I have a massive csv file thats linked to an excel file as "data model" & connection only, lets call it Master. Now this csv file arrives weekly with a different name, so week 1, its called Week 1 and that rolls each week. In the Master, you have the following tabs: Data and...

Hi, I need to search column B for any cell (there will be multiple) that contains 'subtotal' in the string of text (there will be 'Subtotal - Section 1', 'Subtotal - Section 2' etc). Then a message box to pop up asking for the Rev Code1 for that subtotal section and for the Rev Code1 the user...

Please help! I want to search a text from a cell in a column and find out Row # and paste the row number in next sheet and copy paste whole row next to that. Eg. <tbody> Text String Row # Table info Table Info Account 2 <tbody> EscrowAccountStatementDate </tbody> <tbody> date on...

I want to search a cell for a string in a range. If one of the strings within the range is found, I want to use a vlookup to return a value from a grid. How would I do this with VBA? Here is an example of what I want to do (I apologize in advance for the wonky formatting on the bottom grid)...

Hello Group, I am working on a project and need some help. I have a sheet that contains a pivot table Range A:Q and need code that will look in Column A for the string "Total" (will contain other text besides total) and then look in that specific Row columns F:Q and see if the cell is greater...

Hi Everyone, I am wrapping up a project and need a little help with adding an if statement to my code, not sure the best way to do this so was hoping for some help. Background Using the find method the code loops thru a list of values in sheet "DataSource" and when a value is matched on Sheet...

I have a spreadsheet with rows of customer data. Each Row has a column with Distributor Name (Column H) and a column with Customer name (Column J) I have another sheet in my Workbook named “OEMs” which has a Named Range of “CUSTOMERS” I want to search through all the rows in my spreadsheet...

Hello - I need to search a cell for two strings. If either of the two strings is found insert "YES" in the formula cell; if not, insert "No". Example: If "WRITE" or "RW" is found in column A, insert "YES" in column B, else insert "No" Column A Column B...

Hello, I have this excel file (*.xlsm) that I lost track of it (don't know where it is). I am using a search application "Effective File Search" which allows searching for a string inside a file. It looks like it works for ASCII files but not for binary files. I have specific keywords that I...

Hi, I need to search a range of cells for a given string of text and display the cell contents for any cells in the row which contain the search criteria. Example:- String to search is entered in B15. I need it to search each row and display (in column G) the full data for the match. No more...