search string

  1. H

    Matching specific email address domains from string

    Hi. We have hundreds of users with at least 8 different proxy addresses/aliases. They cover various email domains, with a mixture of firstname.lastname@domain or PIN@domain. One example is Joe Bloggs, who has these email addresses associated with this account...
  2. tljenkin

    Search Loop VBA

    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...
  3. J

    Msg Box based on part string

    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...
  4. Shreesurya

    Find text from Cell in a Column and Retrieve row # and paste the information.

    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...
  5. D

    If string from range is found then VLOOKUP

    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)...
  6. Johnny Thunder

    VBA Help - Look in Column A, if cell contains "total" Then Function

    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...
  7. Johnny Thunder

    VBA Help - Need to Add an If Statement to my Working Code - Add value if not found

    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...
  8. S

    Searching using a Named Range

    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...
  9. S

    Finding a string in a cell

    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...
  10. K

    find string in vba module from outside excel

    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...
  11. B

    Search string in range of cells and display full cell contents

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top