find all

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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