find a value

Hi all, I have to say that I am quite new to excel. I create a function that returns a cell that contains a value starting at certain cell. The problem is that sometimes it find the correct cell others (for the same value) it doesn't. Here is my code: Public Function...

Hello I need a macro to run every time I press a button (form control). It should read the cell value (number) in cell i3 then it should look in columm B3-B20 for that value in case it finds it, it should delete that row (row a-g) it should also create a new row so the total number of rows...

I am having a row with values from 21 to 45 and continued again from 1 to 25 <tbody> Some unknown number of rows in the beginning 25 26 ... 40 41 42 43 44 45 1 2 3 4 . . 24 25 </tbody> to find column position of "1" i am using code Worksheets("sheet1").Rows(2).Find(What:="1"...

I have split columns before using the (LEFT,RIGHT,MID) statements after finding a character, but this is my challenge. I have a column that has multiple "\" characters in variable positions and all the text between them and the last characters after the last "\" needs to be in separate fields...

Okay first just let me say WOW AWESOME FORUM AND SITE!!! I'm really pretty new to Excel formulas, but I'm totally geeking out on it. It's so cool! Anyway, I'm trying to get a formula to do the following: [Example] IF (there is the word "Tyrion" in either A1 OR A3) AND (there is the word...

Hi there, I have a list of text entries eg A1="this dog is a brown one", A2="why is my cat yellow?", A3="the red bird flew away". I would like to search these entries to find a match with any one of the following list, D:D="red, blue, brown, black, yellow" and return the word that matches, eg...

Hi All, I am trying to calculate months remaining between two dates, I am trying with below code, but doesn't do anything...Kindly help.... Sub ChangeMonthsRemaining() Dim cl As Range Application.ScreenUpdating = False For Each cl In Range("$D$2:$D" &...

Hi Guys, I am looking for VBA code to search for multiple entries and if those multiple entries are "True" then the code will pass the Answer in a Textbox as "Hired" or "Available" Basically I am trying to develop a little program for Hat Hire whereby if I enter the Date of when the customer...

Hi Guys, I am looking for VBA code to search for multiple entries and if those multiple entries are "True" then the code will pass the Answer in a Textbox as "Hired" or "Available" Basically I am trying to develop a little program for Hat Hire whereby if I enter the Date of when the customer...

Hello All, I have a requirement where i have to search a value of cell in the C:C range and find all values found in that column, if the values are found then i have to copy the value of first string in A:A range. Example: A B C 1 Cat Cat 2 tiger Cat 3 son Cat here in column...

Hi Friends I have been working on a macro which copies data from individual sheets to the Master sheet. In a easy way out I created the below given macro which copies all the data from individual sheets to a new sheet and rename it as Master sheet. But there are practical issues in it. So rather...

Hi everyone, What my code is trying to achieve overall is go through the rows of one column, and match 3 elements in each row with 3 elements found in one row of the adjacent column, like a b c d e f x y z a b c To do this, I am using...

Hi, vba newbie here. I'm trying to use the set range function to search if a string exists within it. If it cant find the string it added the string to the next row. This is fine and works correctly with the following code: Set r1 = Range(Sheets("Sheet1").Range("A1")...

Anybody can hel me I want to make marco to find a value form several value For example: I have a value = 12 And i have some value 5 2 1 4 9 so excel will be inform that 12 is from 6,4 and 2 any body can help me <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END...

Hi Everyone I'm new here, and excited to join the community thanks! I need some help on a VBscript / Macro I was trying to make. Rep Name is Column J Row 5. I need to find multiple columns based by the header which is row 5, if column range (j5:az5) is “Video – Actual” then copy column to sheet...

Hello All I am trying to write a macro which looks at the value in a cell, and if it is empty moves up one cell, and does so continuously until the active cell has a value, at which point it makes the active cell bold. I tried using the .Find method but that code did not stop at the first cell...

Hi, I need help from you experts on this problem I'm having: I need a macro to go through the values in column A in the "reference" tab and check if the value already exist in column B in "master" sheet. If it does, then copy value from column C and paste it to column F in the "master"...