Results 1 to 9 of 9

Extract the data within the specific date range

Threaded View

  1. #1
    Registered User
    Join Date
    04-21-2015
    Location
    HK
    MS-Off Ver
    2007
    Posts
    40

    Extract the data within the specific date range

    Hi guys,

    Sorry to bother you guys,

    If i have a few columns and rows of data

    For example

    A B C D
    Tom HK Boy 1/1/2015
    Peter US Boy 10/3/2001
    Mary UK Girl 7/2/2015

    If i wanna extract the entire row, with the speific date range, like after 1/1/2015,
    wanna move the entire row to a new sheet for record, and before 1/1/2015,
    wanna start another new sheet for record.

    I have used lots of dumb ways, like change the date into numbers, and rearrange them and copy to the new sheet,
    but cant vlookup the data through the date, because the date may get the same.

    Wanna take it simple.

    Hope you guys can teach me a solution. Thank you so much guys!
    Last edited by nth34; 05-03-2015 at 09:24 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Extract Specific Data from range dependant on text criteria
    By Grimace in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 07-09-2013, 08:43 PM
  2. extract data by date range and place in different tabs based on name
    By Sway1978 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-20-2013, 03:35 PM
  3. extract data from a date range
    By Spherous in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-21-2013, 11:50 PM
  4. Extract Data from Chart using a Date Range
    By Purplestar85 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-14-2013, 05:36 PM
  5. Extract dates for specific days in a date range
    By Ricker090 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-13-2011, 09:36 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