+ Reply to Thread
Results 1 to 6 of 6

Extract records records between Two Dates while one column value is same

  1. #1
    Registered User
    Join Date
    03-09-2010
    Location
    united arab emirates
    MS-Off Ver
    Excel 2007
    Posts
    47

    Extract records records between Two Dates while one column value is same

    I am looking for help to solve the problem as below
    I have an Excel sheet with 2 sheets one is Data and another is Extraction. I would like to extract all records and copy with Macro to sheet “Extraction” between a Start date (Colum P2) and End date (Column P3) while Q2 value is same.
    Attached Files Attached Files
    Last edited by AliGW; 07-16-2022 at 02:23 AM. Reason: Redacted for legibility.

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,516

    Re: Extract records records between Two Dates while one column value is same

    See if this works at your end. (tested here and works)
    Please Login or Register  to view this content.

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Extract records records between Two Dates while one column value is same

    FWIW are you still using XL2003 as stated in your profile? If not please amend accordingly. Thx

  4. #4
    Registered User
    Join Date
    03-09-2010
    Location
    united arab emirates
    MS-Off Ver
    Excel 2007
    Posts
    47

    Re: Extract records records between Two Dates while one column value is same

    Quote Originally Posted by jindon View Post
    See if this works at your end. (tested here and works)
    Please Login or Register  to view this content.
    Thank You so much for your kind help

  5. #5
    Registered User
    Join Date
    03-09-2010
    Location
    united arab emirates
    MS-Off Ver
    Excel 2007
    Posts
    47

    Re: Extract records records between Two Dates while one column value is same

    Sure I will

  6. #6
    Registered User
    Join Date
    03-09-2010
    Location
    united arab emirates
    MS-Off Ver
    Excel 2007
    Posts
    47

    Re: Extract records records between Two Dates while one column value is same

    Quote Originally Posted by Pepe Le Mokko View Post
    FWIW are you still using XL2003 as stated in your profile? If not please amend accordingly. Thx
    Sure I will

+ 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] How To Extract All Records Between Two Dates In Excel
    By Teblol in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-28-2021, 06:36 AM
  2. [SOLVED] Extract records between dates on multiple condition
    By sanjuss2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-12-2021, 02:01 PM
  3. Extract unique records with date criteria: between 2 dates
    By Phlebas1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-19-2019, 01:48 AM
  4. Changing Column Records to be in Rows as Records
    By Yeiby in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-26-2018, 05:39 PM
  5. [SOLVED] Extract records between two dates with criteria - Gap analysis
    By bala04msw in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-28-2016, 05:45 AM
  6. Extract records from a data sheet with name and dates criteria
    By ovgarcia24 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-01-2016, 12:11 PM
  7. Replies: 2
    Last Post: 12-04-2014, 04:59 AM

Tags for this Thread

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