find a value

I have some code, that when run from the current workbook (a template), it opens a different predetermined workbook (Sales Log), performs a find in column "A" in the Sale Log to determine the corresponding row of the item # from the template, and places certain results in the Sales Log in that...

Hi All, Have a worksheet with a lot of data and I'm building a search VBA that hides/unhides columns based on 2 cells containing user entered data (from drop down menus). The first "For" function works without a problem, its easy since it's reading from a range with a single row, the second...

Hi there, I have some code that is speeding up some checks that I do every week over 1000 rows etc. I am just after a little help in speeding up my checks as this is tedious work. What I am after is for a macro to check if the the previous column (i.e. Column R) has the same value in it and and...

I have a combobox that populates with a dynamic list of check numbers based on the employee selected in a listbox. The check number values in the combobox change each time a different employee is selected in the listbox. These check numbers are "imported" from different worksheets in another...

Hello, I am trying to determine how I can search cell contents for specific values (a calendar week value) and then extract the corresponding value entered on an adjacent cell that are the hours worked in that week for a given project. I cannot import an image or screen shot, so I will try to...

I am using the following method to find the uniqueID supplied by a user on a sheet: Cells.Find(What:=uniqueID, After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=True).Activate When I...

I have the below code which finds text based on what is in cell D1. I have a button connected to this code but what i want to happen is when the user presses the button once its finds the first instance, then if the press again it goes to the 2nd and so on down. Currently it just finds the first...

I have a Do until statement wrapped in an If statement and this is the Do until code I am using: DEPI = Sheets("MTN").Range("A1").End(xlDown).row Set findrange = Sheets("MTN").Range("A1:A" & DEPI) Set foundcell = findrange.Find(What:=Sheets("MTN").Range("C1").Value, LookIn:=xlValues...

Hello, I would like to run a search and find cells in my column A that contais the following text: "account - xxxx - services". Then I would like to extract these "xxxx" value from the cells in the original sheet and place it in cells in another sheet. Thank you, Karen

I received a spreadsheet with a list of customers (around 200) that I need to find in another larger spreadsheet (column with around 2K customers) in order to obtain their ID code. What is the easiest way to do so? The column with the larger number of customers has a filter, which I could use to...

In VBA is it possible to delete the whole columns containing the word "No" in the range of C2:AM2 ? Thanks in advance

So I'm missing something simple but I just can't see it. I'm using .Find to search cells in a range("J6:BFA6") dim'd as "Name" for a user entered word from range("E5") dim'd as "NameS". If the value isn't found, the column becomes hidden, if it's found the column unhides. It hides the columns...

Hello, I am using the code below to loop through all of my sheets, find the sheets that are named "Labor BOE...", then find the text "Method of Quoting:" within column B, and resize this row. I was also hoping to merge the 15 cells to the right... so this would mean it would find "method of...

Hello. I found lots of info about avoiding divide-by-zero errors, but I can't find any info on how to FIND div-by-zero. I have several large spreadsheets that were sent to my by another person, and I would like to audit them. I need an easy way to indicate the cells with div-by-zero errors...

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

Hello everyone i have small doubt i have created a userform with few combo box,now the issue is when i select values from few combo box those values should get added after a word ,for example lets in cell a1 there is statement "THIS IS PEN" which is predefined and when i select a value in combo...

Hi, I need a code to lookup up a value (such as "Q1010") on a worksheet(1) and when found, put the values from its left and right cells on a list in another sheet(2). It would be nice if the new sheet(2) list could be organized by numerical order according to the value of the cell on "Q1010"...

Hi, I have a for loop (provided as an answer to a seperate question), this loop moves through every row with a value in column A. I now wish to reuse this code in a new way, to remove any rows that contain 110 or 111 within column A. I have drafted the below code but am not really sure...

I have an array which contains a list of values, which I want to check if any of them appears in another cell. let's say my array values are in A1:A4: A1: 4.1 A2: 4.2 A3: 6.2 A4: 6.3 Now I basically want to search for each row I have the data in if one of the values of A1:A4 appears within...

Hello, I am a self-taught VBA writer, and my work is wanting me to do something beyond my knowledge. I have a table that contains Vendor, Platform, Model, Category, and Component. I need to have a list off to the side containing a list of Platforms and Components that can be added to, but the...