+ Reply to Thread
Results 1 to 2 of 2

Macro to sort data within a date range

  1. #1
    Registered User
    Join Date
    10-11-2017
    Location
    Hong Kong
    MS-Off Ver
    2019
    Posts
    55

    Macro to sort data within a date range

    Dear all,

    I want to use macro to sort the raw data within a date range. In 'Date' sheet, Start Date is variable while Today is fixed as system date. When I enter the start date, the macro can help me sort the data from 'Raw data' sheet. Within the date range, the data should be remained. Without the date range, the data should be sorted out. The result I want is in 'Raw data sorted' sheet.

    It would be greatly appreciated if you could help.

    Jack
    Attached Files Attached Files

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Macro to sort data within a date range

    Try this link;
    https://www.extendoffice.com/documen...two-dates.html

+ 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. sort data according to name of product and date range needed
    By mazan2010 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-12-2017, 11:17 AM
  2. Macro to sort data in two groups conditional on date
    By electricninja in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-06-2017, 10:16 AM
  3. [SOLVED] Macro to sort data range
    By roversfan09 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-04-2016, 01:25 PM
  4. Macro code to automatically sort column by date range
    By holmit in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-03-2016, 07:18 AM
  5. How to create macro to sort data in dynamic range
    By Luke82 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-10-2013, 06:16 PM
  6. macro to sort data in worksheet by specific date
    By joey in forum Excel General
    Replies: 0
    Last Post: 11-14-2005, 04:10 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