find next

  1. C

    Find previous value = "PUMP ON" and subtract from current row

    Hi, I have what is probably an easy Excel question that is giving me some difficulty. I have a spreadsheet of Date/Time in Column A, Tank levels in column B, and in some of the rows I have an identifier PUMP OFF in Column N, and in some rows I have an identifier PUMP ON in Column N (Pump On/Off...
  2. T

    Macro has hard code first cell, how to find next cell with data

    Hello, In the link below some code is hard code referring to specific cells. I thought the source was always going to be the same column, however I just ran it a few times and found a glitch. In this line of codews2.Range("A1").Value = ws1.Range("BL3").Value BL3 was always the cell or so I...
  3. A

    VBA: Find & Find next function: Return multiple value in a single cell if the ID match

    I am using find function to match ID in Report Worksheet with the ID in Data worksheet and return the data to the ID in Report Worksheet if there is a match. For unique with multiple match, the code is only returning the ID data which every is last match in the search range in Master worksheet...
  4. W

    Find next Function using 2 criteria help

    Hello All, First of all sorry if this is answered somewhere already, but I didn't know exactly how to word it. I am an Engineering Intern that has somehow been tasked with writing Excel Macro for the last month. I've taught myself quite a lot so far but cant figure this one out. The first...
  5. J

    Another Darn .FindNext Question

    Hello everybody, While not a beginner, I clearly have somethings to learn here... I have not been able to get the .FindNext function to operate within my code. It's irritating because I thought I knew what I was doing. I am attempting to update a spreadsheet on the network from my desktop...
  6. J

    Help with loop macro, find next

    Hi there, I seem to need a little help with my loop. values and rows will change. I'm looking at values in column A, if the value is the same as the value below (A2 - A3) delete A2, if it is diferent then move to the cell below. this is my code Dim rCell as Range Set Rngy = Range("A2:A" &...
  7. K

    Find text between delimiters in a cell and extract text between the following delimiters

    Hi, I've spent months trying to research a solution to my problem and after reading another post from your site that was very helpful for a different issue, I thought maybe you can help me. In A2, there are a list of headers followed by descriptions, one-after-the-other. For example, I have...
  8. L

    VBA Search Box - needs try again option

    Hi All I found some code online to run a basic value search on a column. I have modified it to suit my needs, but as I would like to add the function to "Try Again" if the returned result is not the correct one. I need this because the search is for names, and the sheet used by lots of people...
  9. B

    Creating my own search box to find a keyword and then an option to find next.

    Good morning all, I am having some problems with some code. I want to be able to search for keywords in a spread sheet with the option to find next. I understand that I can press CTRL-f but I would like to have a cell with a search box. I have done all I can to get this to work but so far...
  10. 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...
  11. S

    VBA for Find Word, run macro, find next....

    <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...
  12. E

    Find Insert Multiple Occurences

    I need help with an Excel Macro. I need to find each occurence of 24 different TEXTs and next to each insert cells to add additional information. The number of occurences of each text varies and may appear in the range of K2:IV2000, so there may be for example 14 occurences of TEXT1 and then 35...

Some videos you may like

This Week's Hot Topics

Top