find a value

Hi, I am quite new to VBA and have spent the better portion of the day reading forums so I thought I would just ask because I am stumped. I would like to have a macro that searches for a value in a specific cell in a column on another sheet. I simply want to select the first match in the...

So if I have three adjacent cells: 0 3 0 I want to keep this data. But I also want to sum these three numbers up. The issue is that the "3" is equal to a "N/A", so I dont want to include it in the sum. How can I add these three cells up without including the 3? Note that the placement...

Hi Gurus ! I have a big database of Employees that has a unique key "ID No." now What I want is that if I enter 'Jon' in a cell then the I should be able to find all employees who have substring Jon in their names, and their names & ID no. should appear as a list. The expected result is...

I want to copy a cell from an active sheet to a summary sheet using FIND. Just not hitting it yet. I found some code from DeBruin that may get me started. Once I copy the cell in the active sheet I want to scan a SUMMARY sheet where my value from the active sheet will be in Column A. Once it...

Hello everyone, first time posting here. I'm trying to retrieve information from a table like the one below as such: <tbody> A B C(function) C(outcome) 1 a Harry =IF(A1="a","YES","NO") YES 2 ab Ron =IF(A2="a","YES","NO") NO </tbody> Basically if a cell in column A contains "a" I want...

Hi All, I need to do search a keyword in master column by vlookup, example: <tbody> NAME (Column A) SHORT NAME (Column B) Result (Column C) AIRTEL (SL) LIMITED <tbody> COMMITTEE </tbody> #NA <tbody> GOAL </tbody> <tbody> COUNCIL </tbody> #NA <tbody> INTERNATIONAL COMMITTEE...

I am trying to see if a certain text is contained in a list. My next that I want to search over and see if it contains a value in a list is in column E and the list is located in column G. In column F i want to print Found if the number from G was found in E. Below is the formula that I used...

Hi, I tried to use this code in VBA if ClName.Formula = Evaluate("=if(iserror(find("ccs",ClName)),0,1) "=" 1 then I know it is not correct, but here is what I am hoping to achieve. I would like to check the variable ClName to see if it has an extension of "ccs". For example the clients...

Hi, I'm new with VBA but did quite a bit of macros last week with the help from this forum. Now I'm stuck with this one and can't figure it out. Any help is much appreciated. I have a schedule something like this on Sheet1: <tbody> Name Mon Tue Wed John Surrey 0900-1700 Van 1230-1945 APH...

Hey all, I'm hoping someone can help me with the issue I'm having. I have a macro that does a bunch of stuff on several tabs in an excel worksheet. One part of the macro creates 2 subtotals and then hightlights and bolds the total lines for each. The subtotal is grouped by column L and summed...

Hello. In excel, after I search and click "find all", I want to see the matching adjacent column values in the results list (so I can compare the results). Is there a way for me to archive something like this? Or perhaps a software that does this? Thanks!

I need to find a specific value in a column and then sum a specific range in that row belonging to the value, but the column location changes whenever someone inputs their data for their specific project, even though the value doesn't. Is this possible in a formula or would that require a...

Hi I have below table <tbody> AT PT FT 5 12 8 6 10 2 12 4 13 3 22 4 </tbody> I want to find smallest PT that AT belonged PT <= FT , then founded PT + FT(old)=FT(new) and founded PT ignore in next row calculation, and repeat trend in every row whit excel function. for example...

Hi guys, all time fan here who is in desperate help for the first time. I've been searching for an answer all around the web with no positive outcome. Here is my situation: I've been using a code for quite a while that was working smoothly, but all of a sudden now stops and shows me an error 5...

Hey guys, I'm a bit new to this but am starting to get the hang of it but could use some help. I have a large data file with several different worksheets. In one cell I have a large set of individual numbers (i.e in the cell there is "123456 234234 939829") This value is my 'sample' number...

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

Hello Everyone, I would like to create a rule that finds a set of numbers in a table and highlights the rows that matches the exact numbers: - All numbers must match in a row in order to highlight the rows. - Numbers order is not important. - Advanced: ability to control how many of the...

Hello, I am trying to achieve something similar to a Vlookup I guess. I want my code to: Select first cell of range in spreadsheet 2 Find it in spreadsheet 1 If found highlight row and paste cell value in adjacent cell Move down one cell in range Loop until end of range Here is what I have...

So I have a bunch of different excel documents that all have the same info under the same headers, but they are not all in the same cells (So in one it might start with part names in cell A5 and another might start with Part number in Cell A2) I would like to be able to get rid of my current...

:) Okay here goes!! I am new to this so if its an easy question I am really sorry!! :( I have to get this done for my boss as soon as possible!! Basically this is what I need as a formula. Plus it's over two sheets. If B1 (sheet 1) = "TEXT1" ,FIND the content I1 (sheet 1) within a1:a3000...