+ Reply to Thread
Results 1 to 2 of 2

How to extract data from another worksheet based on Start Date, End Date

  1. #1
    Registered User
    Join Date
    01-28-2016
    Location
    Ontario, Canada
    MS-Off Ver
    Microsoft Office 2013
    Posts
    2

    How to extract data from another worksheet based on Start Date, End Date

    Hi,
    I have a worksheet, where user selects a Name from a ListBox, then types in Start Date & End Date. Then presses an 'OK' button. What I want is data to be extracted from other worksheets in the same workbook based on the information given. What would be the way to look up values under certain criteria's in VBA?. Help is greatly appreciated!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: How to extract data from another worksheet based on Start Date, End Date

    A possibility could be next code
    Where is
    ' Code to test dates

    put some code to check dates
    If you need this code, explain what sort of checks must be done

    Please Login or Register  to view this content.
    Last edited by PCI; 04-18-2016 at 04:01 PM. Reason: Change for a smarter code
    - Battle without fear gives no glory - Just try

+ 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: 3
    Last Post: 02-10-2016, 07:26 PM
  2. Counting if data falls on date between Start Date, End Date or Possible End Date
    By JessHasQuestions in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 07-26-2014, 08:01 AM
  3. Calculate next due date based on start date frequency and current date
    By ironoverload in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-09-2014, 07:08 AM
  4. Replies: 0
    Last Post: 03-21-2013, 12:22 PM
  5. Replies: 0
    Last Post: 07-03-2012, 03:52 PM
  6. Replies: 4
    Last Post: 06-02-2012, 11:26 AM

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