find all

  1. B

    VBA VLookup or Match Function to return Rows instead of Single Cell Value That Meet Condition

    Hi Community, The following code works perfectly for returning a single row that meets a specific value, but if there are numerous rows that meet the given condition in range A:A it only returns the first row, and not any additional rows that meet the given value. Any guidance here. Private...
  2. D

    find all values corresponding to each values

    hi all, I want vba code for following activity. Sample data is provided below. Copy each value in 'Find value' column and find all in column 'For Topic 1'. Paste the find all values in the column 'Topic 1'. Repeat this activity for all column Topic 1 to 4. <tbody> Find Value Topic 1 Topic 2...
  3. D

    Data extraction

    Hello everyone i have assigned a work in excel like find the word for example in column A i have list of words and in column B i have list of words so now i want to create a program like if i type particular word from Column A or Column B the cursor should go to that particular row where that...
  4. A

    Find Multiple Values, Copy to new Sheet and Count Number of times each entry appears

    Hi, I have been battling to find anything online that can assist me. I have a sheet that has email addresses in them and need to Find each email address and generate a list of all email addresses and how many times they appear in the sheet. I can use an Array with FindNext but how do I get it to...
  5. A

    Find and copy corresponding value to another cell on another sheet

    Hi, I need assistance with my code as I am struggling to find a solution. I eventually split the array in two as I was getting an error. I am searching for words in sheet "ServiceType_SubType_Item_byComp" and copying the offset value to sheet "Charts", but often there are two cells with the same...
  6. A

    Help with find function to search records and copy associated hyperlinks

    I am new to the forums, and really new to VBA in excel. I have found some code to search for a text string, and I tried to adapt it to search through sheets in a workbook for a string "Logs" and then copy the cell 2 columns to the right. Then I am trying to paste the hyperlink at the end of...
  7. G

    Find/Replace Window

    Hello, Is there and way to code so that the Excel Find/Replace window opens, is resized to be bigger, and the window stays there waiting for user import. Macros doesn't like it Thanks
  8. G

    Name column in find all window

    Hello, If in Find window when Find All is selected a list comes up with Book, Sheet, Name, Cell, Value, Formula. Where is Name column looking now and can I direct it to a range of my choosing? Thank You
  9. G

    Name column in find all window

    Hello, If in Find window when Find All is selected a list comes up with Book, Sheet, Name, Cell, Value, Formula. Where is Name column looking now and can I direct it to a range of my choosing? Thank You
  10. F

    "Find All" is showing wrong count

    I have a range of data, this data includes articles with HTML codes. Each cell have one article and a total of 200 articles therefore 200 cells. To explain in short, each cell have the word "<footer" in it. What I want to do is find the exact text "<footer" and replace it with, lets say any...
  11. Sam Calabrese

    Hilight entire rows containing selected cells

    Most of us know the 'trick' where we use Excel's Find -> Find All option, then press CTRL-A to select all the result cells containing the search target. Then we exit the search dialogue and apply formatting to the cells (which remain selected). To highlight entire rows containing the selected...
  12. T

    FindMethod on VBA Userform specialCells property not working properly adding to listbox please help

    I have a find records function on my database. The first part works perfectly. It will check for the search string, find how many instances of it there are in my datarange, then if the user clicks Okay it will findall records and add them to a listbox. Here is my Code maybe one of you can see...
  13. O

    VBA to find Value, then Name Cell

    I want my code to do two things. 1) Locate the cells in Column A that have a certain value 2) Name the cells with that certain value All the values will be in Column A. The word I am searching for will appear three different times in the column. I need a code that will find those cells and name...
  14. P

    Sum a column based on one criteria

    Hi Guys, I have been wrecking my head with the following! hope you guys can help? I am trying to look for some VBA Code so that I can search multiple values in Column "A" based on the criteria in Textbox1 and SUM up the corresponding values in Column "B" based of course on the criteria in...
  15. P

    Find multiple Dates & a Number and pass result to Textbox as true/False

    Hi Guys, I am looking for VBA code to search for multiple entries and if those multiple entries are "True" then the code will pass the Answer in a Textbox as "Hired" or "Available" Basically I am trying to develop a little program for Hat Hire whereby if I enter the Date of when the customer...
  16. P

    Find multiple entries

    Hi Guys, I am looking for VBA code to search for multiple entries and if those multiple entries are "True" then the code will pass the Answer in a Textbox as "Hired" or "Available" Basically I am trying to develop a little program for Hat Hire whereby if I enter the Date of when the customer...
  17. D

    Find All, Copy Adjacent Cells, Paste in New Window

    I need to separate numerous data entries by year, so I need to find all entries containing the year in question, copy the cell year is listed in as well as 2 cells on either side, and paste the 5 cells into a new spreadsheet. Here's the code I have closest to working...
  18. A

    Find Next within For

    Hi everyone, I have a list of production lines in one worksheet, say Production Line 1 Production Line 2 I go through the list of production lines with the help of For and a variable that takes the name of each line in turn then I go into another list and for each production line a variable...
  19. R

    Newbie question - sorry in advance

    I apologize in advance for a newbie question (but im learning :) ) I have a worksheet with around 10,000 line items, about 2000 of them are the same or similar item, yet are all over the sheet and not in order. Is it possible to do a "Find" or a "Find / Replace" for an item say in Column E and...
  20. I

    Mass find options

    Hello All, I have a sheet of about 4500 entries, and on a second sheet of about 2000 entries, is there a way to a mass search to find any duplicates? As at the moment I am doing line by line Find (Ctrl F) and its getting boring!! there are muliple columns that can be search, ie invoice...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top