+ Reply to Thread
Results 1 to 2 of 2

How to extract into seperate workbook based on a date range from today to 7 days out

  1. #1
    Registered User
    Join Date
    01-19-2015
    Location
    Newport, RI
    MS-Off Ver
    2010
    Posts
    1

    How to extract into seperate workbook based on a date range from today to 7 days out

    I am looking to have something set up where I can update to today's date and have it show me the shipments that are due to arrive and depart within the next 7 days. Each row has about 20 columns of data including both ETD and ETA and I'm trying make a little chart with ETD/ETA and few other key elements. Is this possible? Thanks in advance.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: How to extract into seperate workbook based on a date range from today to 7 days out

    Sorry, but we'll not be able to visualise this unless you attach a sample worksheet. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ 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] COUNTIF anumber of entries in a date range 14-30 days before TODAY?
    By HeathWilD in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-31-2015, 05:47 PM
  2. Replies: 4
    Last Post: 01-17-2013, 01:23 PM
  3. 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
  4. Display a Value based on Today's Date in Date Range
    By barella in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-12-2010, 06:25 AM
  5. How do I add a range by date over 90 days older than today
    By John DeLosa in forum Excel General
    Replies: 4
    Last Post: 02-16-2006, 05:35 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