+ Reply to Thread
Results 1 to 2 of 2

Date Match?

  1. #1
    Registered User
    Join Date
    03-20-2014
    Location
    Northampton
    MS-Off Ver
    Excel 2010
    Posts
    3

    Date Match?

    Hi, would like to enter in the code the procedure checking whether the date chosen in the userform already exist in the list, as the row for each date may have got multiple entries. Therefore I would like to make sure that there is no blank space left. If the space already taken then put the date into the new row. Would really appreciate your help guys....
    PLease find the file attached....
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    03-20-2014
    Location
    Northampton
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Date Match?

    To be more specific. The userform in the file includes the date entry. The spreadsheet may have multiple dates in the list that may repeat. Each date may have multiple entries for different locations and different stores. What I would like to do is to chechk whether the date already exists. If yes then to check whether there is any space for the location entry, etc. If not, then to enter new date with this location and another specific info. ....Or there might be some different way (layout) carrying out similar procedure?
    Last edited by kueljo20; 03-25-2014 at 05:37 AM.

+ 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. [SOLVED] Index Match Based on One Date Criteria, Table Contains Beginning Date and End Date
    By jcox1953 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-09-2014, 02:41 PM
  2. [SOLVED] INDEX date that MATCH on date range, MATCH code(string)
    By Dahlia in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-23-2014, 03:33 AM
  3. [SOLVED] VBA worksheetfunction.match doesn't match DATE. Userform
    By stevnb in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-05-2012, 09:08 AM
  4. Replies: 5
    Last Post: 01-07-2012, 10:17 AM
  5. Replies: 5
    Last Post: 01-06-2012, 08:00 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