Results 1 to 25 of 25

How to pull multiple dates under one customer name

Threaded View

  1. #1
    Registered User
    Join Date
    06-23-2015
    Location
    michigan US
    MS-Off Ver
    2010
    Posts
    34

    How to pull multiple dates under one customer name

    i have a report ran everyday for shipment dates and is placed on another sheet. i want to know if it is possible to pull in multiple dates when i pull the report on Friday.
    ex. On Friday for KIMS there is a shipment for 6/25 but on Monday, the shipment was canceled and the next recent is not till 7/20. i want to be able to pull both the 6/25 date and the 7/15 date in on friday so i know what the next shipment is in case a delivery is cancelled and the next date is soon after.
    if possible i would like it so that the next date shows in the row beneath the row with the customers name with out having to put a different formula in each cell

    I have multiple parts that i run a report for that shows me the shipping date. i would like to be able to pull in more than the first date in. so i paste each day's report into a different sheet using v lookup and it all pulls onto sheet 1 and shows as the chart on top.
    i would like it to pull so that it skips the the date it already pulled and put a line similar under it if possible. i have almost 400 parts to keep track of daily so it would suck to have to add the lines myself but i will if there is no other way. so if it will be efficientand work with alot of numbers would be awesome.

    Thank you in advanced!
    Attached Files Attached Files
    Last edited by JBeaucaire; 06-25-2015 at 10:02 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to pull multiple dates for customer
    By webber15 in forum Excel General
    Replies: 4
    Last Post: 06-23-2015, 03:39 PM
  2. [SOLVED] Pull first end customer for each account
    By janeml in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-06-2014, 06:57 PM
  3. Replies: 11
    Last Post: 06-19-2013, 04:26 PM
  4. How to pull transactions into a template based on a customer code?
    By The_Snook in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-06-2013, 03:34 PM
  5. Replies: 1
    Last Post: 12-14-2012, 05:39 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