find

Evening all, I am pretty new to VBA and I could really do with some help with a spread sheet. I need to copy data from multiple rows (I only need up to offset 0,10 from these rows) when a cell in the range A1:A30000 in the sheet entitled DATA equals the value of TextBox7, to another sheet...

I am trying to take my current code, that uses a Find function to search for the value in cell "H4" (this value is in the worksheet where the code is) and find it in a second workbook searching from Columns A3-A100000 (Find functions start at the next row after the first, hence why in my code I...

Hi All Have issues with this formula =VLOOKUP(FIND("*",SUBSTITUTE(A8,".","*",LEN(A8)-LEN(SUBSTITUTE(A8,".","")))),Data!B:C,2,0) What i want is to do a Vlookup on everything in the cell up to the full STOP (.). This formula is giving me the position of the last full stop...

Hello! Is it possible to find a part of a word and delete it ? I have a column like : LaviniaAdm as exp AndreeaAdm not there LauraAdm adminansdghjk . . . And so on. A name followed by Adm written together. I have a long list so I don't want to delete it manually. Is there a way to insert a...

Hi, I'm really need help with this. Been trying to achieve this for the last 2 days. On my first worksheet, I have Values in column A and column B there are also values but they are hyperlinks. I'm trying to find the cells with the values from A across the rest of my worksheets and and replace...

I have a list of correct and incorrect names as seen in sample file below. I am trying to loop through a list of sheets and do a find and replace for each item on the List. The Correct Name is what the replace is going to be and the Incorrect Name is the find. I have looped through specific...

Como posso encontrar dados na folha2 e fazer corresponder na folha1, encontrando a intersecção e preenchendo as células com cor

Hi, very new to this. I need help with finding data from one sheet to finding data in another sheet and deleting that row. I have had a lot of trouble with this and cant seem to crack it. Can anyone help a formula?

Hi All, Hope you are all well! I'm struggling to overcome the error in relation to the below code, would anyone be able to help me out? Basically I keep getting the 'Run time error 91' for the bolded section of the below code. In the below I'm searching Column E for the value "4" and if/once...

Hi, I have a database in Excel, where Column A have 100 specific values, that are updated each month, and column B have a price, and Column C have the date which the values have been updated. But some month not all values are updated may only 60 or so. I need a way to get the values closest...

Hi, this is my first post here, i am building a macro where the macro will import data based on cell value from the primary workbook. the cell value will be in workbook 1 but the data will be in workbook 2 and sheet name's will also be n the cell value only, i have build the macro on how to...

I’ve just entered the wonderful world of VBAs and I’ve managed to create this great partial Find function that saves a lot of scrolling and manual filtering. Basically, in my non-technical language, it looks for partial matches by comparing a list of names with a column of other, slightly...

Hello everyone, I want to rearrange some data in an excel table. I have a variable ID_Nr defined as double and it is a number between 2 and 100. I want the macro to look for that number in column A and if found select the whole row and delete it. That way I am trying to eliminate all rows with...

Hi, I am trying to select a column range by first finding which column has the title I require (in this case "UseThis") Then I want to select the range from that address (f.address) and offset it by a number of rows (in this case I am using 100) The code works and msgBox shows $H$1 as expected...

Hello, I have excel with two columns: one is a city, the seconde one is a name of river. I need to find a intersection and get an unique value for each group. Each group is created from the same river and particular cities. If city has two rivers, this should be in the same group. But also the...

I want to find a value among the multiple values in one cell, I hope the given picture will help understanding the actual issue. Hope to get some solution from some Mr. Excel :) P.S :- Please i need some formula instead of VB Code

I currently have a macro set up to find values in a range, however some values dont exist in the column and as such i end up getting an error 91. To get around this, i want it to find the next range. My current macro is as follows. Sub xfg() Dim findnextGL As Range Dim nextGL As Integer...

I used a formula to parse a field that typically contains text like the following: 1F5H or 13F1H The following formula works just fine when the number of digits to the left of a given character is static, like 1 numerical digit. However, I'm not sure how to determine how many numerical digits...

Hey guys, I have this simple code to export as PDF, range AB52 is where it pulls the file name to save as... is it possible to have multiple ranges for the code to look for? I tried "range ("AB52:AB54")" would not work. Is this even possible? If one cell is empty look on the other ones for the...

Hi guys I was wondering if someone could help me with this challenage. I am looking for a formula to calculate a prize based on the prefix (telephonenumber breakout). These breakouts are to call international. See below the prefix and rate example template. It works like this, if the prefix is...