find row

Hi all, I'm working on a macro that updates a database, based on the input of a form. This form is located on a different sheet. My code was working fine all the time until I noticed that it didn't perform any changes when the macro was run from the sheet with the form. That's why I had to...

Hi All, I am new to VBA so still learning. What i am trying to do is have an if formula, that when it matched 2 criteria, it searches in a separate tab within a table for the item with that name. it will then update several fields based on what has been completed within the first sheet. If...

Hi I almost gave up searching when I registered to post this question. Please help me. I have these rows for example: <tbody> 2) What are profits? A) Total money taken in by a corporation B) Increases in income from year to year C) Increases in a corporation's stock price D) Revenue...

Hi All, Assuming Cell : A1 = A B C A2 = D E F A3 = G H I What I need to do is find out what row the letter / word is in. For example if I am looking for the letter "E", I need it to return that "E" is in row 2. I have tried find / match andI cannot figure out how to do it using formulas. i...

I collect orders through e-mailed Order Form Workbooks (file names will vary). When the order arrives, my macro unprotects the Order Form, unhides the Order Summary tab, copies the order data and activates the Order List tab in the Master Workbook, which is already open in the background and is...

Hi There. I am using the .find function to find a value in a range (single column) and return the row number where that value first occurs. When my range is Cells(2,1) to Cells(40,1) and my value that I am trying to find is in Cell(2,1) (the value is actually in first 10 cells) the message box...

<tbody> A B C D E 3/31/2014 4/7/2014 4/14/2014 5/12/2014 Amy x Bill x x Tom x 4/2/2014 4/9/2014 4/16/2014 5/16/2014 Amy x </tbody> I'm trying to count missed attendance based on the person's name (column a) and a range of dates (rows 1 and 6) before...

Hi, In column A I've got dates and in column B I've got different text strings. I would like to find the most recent text string (maximum value in A with corresponding value in B). This to be inserted into a comment, such as this: SisteRev = Range("J10").ClearComments...

I have a worksheet with data collected at 15-minute intervals for approximately one year. Dates are stored in A2:A366. Time intervals (0:00, 0:15, etc.) are in Row#1 (B2:CT1). The 15-minute data is stored in B2:CT366. I need to find the date and time when the maximum value occurs for each...