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

This Week's Hot Topics

  • separating multiple Proper names (uppercase letters) from a list
    I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into...
  • 'for' Loop
    Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to...
  • Open specific pdf in folder with vba
    Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it...
  • What is wrong with this For Loop code?
    I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a...
  • Data to match
    Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I...
  • Shifting Columns
    Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...

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
Top