+ Reply to Thread
Results 1 to 3 of 3

Check if cell value exists in row and if date in row equals date in column

  1. #1
    Registered User
    Join Date
    03-18-2014
    Location
    port vila, vanuatu
    MS-Off Ver
    Excel 2010
    Posts
    12

    Check if cell value exists in row and if date in row equals date in column

    I have two worksheets (ws): client and collections
    'Client' names exists in cell B6 and 'Date' in row range A10 until end of cell with date on "Client ws"
    'Client' names also exist in row range D8 until end of cell with client_name and 'Date' in row range B10 until end of cell with date on "Collections ws"

    I want a macro to do this:
    1. checks if Client!B6 is equal to a cell in row Collections!D8:&...
    2. checks if Collections!A10:&... equals to date in Client!B10&...
    3. if both arguments are true then copy the data on row Collections!D9

  2. #2
    Registered User
    Join Date
    03-18-2014
    Location
    port vila, vanuatu
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Check if cell value exists in row and if date in row equals date in column

    here is my code and i am stuck...

    The comment under the if statement is telling me what to do if the conditions are met

    Please Login or Register  to view this content.
    Last edited by rskay14; 03-20-2014 at 05:50 PM.

  3. #3
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Check if cell value exists in row and if date in row equals date in column

    Welcome to the forum.

    We'd like to help you but first..

    Pls take some minutes to read forum rules and specially-in this case- rule#3 and add code tags around your code.
    Then anyone will be able to help you.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 7
    Last Post: 07-14-2017, 12:04 PM
  2. check for date in mixed text/date and format cell.. Help!
    By berbchid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-24-2013, 03:42 AM
  3. Check if date exists in Named Range "Holiday_List"
    By carsto in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2012, 02:33 PM
  4. Replies: 6
    Last Post: 10-31-2011, 05:22 AM
  5. Compare column B - If exists then update date, else copy to end
    By jimbob121 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-06-2011, 02:21 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1