+ Reply to Thread
Results 1 to 25 of 25

How to pull multiple dates under one customer name

  1. 06-24-2015, 03:49 PM #1
    webber15
    webber15 is offline
    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.
    Reply With QuoteRegister To Reply
  2. 06-25-2015, 02:56 PM #2
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: How to pull multiple dates under one customer name

    Hi webber,

    Can you explain how you knew it was KIMS and is the input on sheet2 with the output shown on sheet1 below the first table???
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
    Reply With QuoteRegister To Reply
  3. 06-25-2015, 03:16 PM #3
    webber15
    webber15 is offline
    Registered User
    Join Date
    06-23-2015
    Location
    michigan US
    MS-Off Ver
    2010
    Posts
    34

    Re: How to pull multiple dates under one customer name

    i just used that example off the top of my head to try and simplize it.
    I run a report every morning and then i copy it to the second sheet. What i have in the file are customer orders in the left column. i pull the delivery date and qty from the second sheet using vlookup off the customer number .
    The top table is what a piece of my table looks like, the bottom table is the one i would like it to look like,or at least something similar. So it is just a before and after shot of the able as it is and howd i like it. Does this help at all?
    Reply With QuoteRegister To Reply
  4. 06-25-2015, 04:09 PM #4
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: How to pull multiple dates under one customer name

    OK so the second sheet has the input data??
    Reply With QuoteRegister To Reply
  5. 06-25-2015, 04:25 PM #5
    webber15
    webber15 is offline
    Registered User
    Join Date
    06-23-2015
    Location
    michigan US
    MS-Off Ver
    2010
    Posts
    34

    Re: How to pull multiple dates under one customer name

    yes that is where i paste the report that i run every day.
    Reply With QuoteRegister To Reply
  6. 06-25-2015, 08:00 PM #6
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: How to pull multiple dates under one customer name

    Hi Webber,

    See if I'm on the right track here - let me know

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 06-26-2015, 02:13 PM #7
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: How to pull multiple dates under one customer name

    Hi Webber,

    Thanks for the rep!

    But, have we got it right? The quantity 50 for instance - where is that? And what about the prior date inserted? Please critique so that we can wrap this up
    Reply With QuoteRegister To Reply
  8. 06-26-2015, 02:32 PM #8
    webber15
    webber15 is offline
    Registered User
    Join Date
    06-23-2015
    Location
    michigan US
    MS-Off Ver
    2010
    Posts
    34

    Re: How to pull multiple dates under one customer name

    where do i putt he formula? i tried to put it under regurlar functions and it did not work
    Reply With QuoteRegister To Reply
  9. 06-26-2015, 02:36 PM #9
    webber15
    webber15 is offline
    Registered User
    Join Date
    06-23-2015
    Location
    michigan US
    MS-Off Ver
    2010
    Posts
    34

    Re: How to pull multiple dates under one customer name

    when i put it into VBA, all i get is a run-time error'9': subscript out of range
    Reply With QuoteRegister To Reply
  10. 06-26-2015, 02:40 PM #10
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: How to pull multiple dates under one customer name

    The sheets must be named "Sheet1" and "Sheet2" or the code needs to be changed to what they are.

    Please Login or Register  to view this content.
    Directions for running the routine(s) just supplied

    If you haven't used macros before you'll need to go to:
    File- options - trust center -trust center settings - macro settings ,
    the second option down (disable all macros with notification)

    Then - Copy the code to the clipboard

    Open your Workbook

    Press ALT + F11 to open the Visual Basic Editor.

    Select "Module" from the Insert menu

    Type "Option Explicit" then paste the code under it

    With the cursor between Sub and End Sub press F5 (F8 to Single Step)

    OR

    Press ALT + Q to close the code window.

    Press ALT + F8 then double click on the macro name
    Reply With QuoteRegister To Reply
  11. 06-26-2015, 02:46 PM #11
    webber15
    webber15 is offline
    Registered User
    Join Date
    06-23-2015
    Location
    michigan US
    MS-Off Ver
    2010
    Posts
    34

    Re: How to pull multiple dates under one customer name

    okay so if i want to run this as a 6 day block,starting with fri, monday, tuesday, wednesday, thursday, friday. as the sheet that i have for the week
    Reply With QuoteRegister To Reply
  12. 06-26-2015, 03:03 PM #12
    webber15
    webber15 is offline
    Registered User
    Join Date
    06-23-2015
    Location
    michigan US
    MS-Off Ver
    2010
    Posts
    34

    Re: How to pull multiple dates under one customer name

    okay so my full sheet will not upload so i took the first 25 rows and made another work book to upload now that the week is over and i have a full report that i can put on here. please let me know if this is better
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  13. 06-26-2015, 03:49 PM #13
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: How to pull multiple dates under one customer name

    So run Friday against Monday, Monday against Tuesday etc??
    Reply With QuoteRegister To Reply
  14. 06-26-2015, 04:02 PM #14
    webber15
    webber15 is offline
    Registered User
    Join Date
    06-23-2015
    Location
    michigan US
    MS-Off Ver
    2010
    Posts
    34

    Re: How to pull multiple dates under one customer name

    i would like to pull more than one date in under a certain part number.
    so for the first part number 140882 there is an order for 24 on 6/23/2015 and another for 20 on 6/25/2015. On monday i would like it to show that second date along with the first date on the line above it. so it looks for the part number ,140882, finds the order for 24 on 6/24, then i want it to go on and look for another date with the same part number.
    i am not sure if it would be comparing the dates or if it is a matter of a command like "if already found skip that order"
    Reply With QuoteRegister To Reply
  15. 06-27-2015, 07:44 PM #15
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: How to pull multiple dates under one customer name

    Sorry to be so slow The information comes from what sheet? AND goes to what sheet(s)??
    Last edited by xladept; 06-27-2015 at 07:46 PM.
    Reply With QuoteRegister To Reply
  16. 06-29-2015, 09:12 AM #16
    webber15
    webber15 is offline
    Registered User
    Join Date
    06-23-2015
    Location
    michigan US
    MS-Off Ver
    2010
    Posts
    34

    Re: How to pull multiple dates under one customer name

    I will have a total of 6 sheets 5 sheets of the information pertaining to each day,and the first sheet being where all the information is shown together.
    Unless it easier to put it onto one sheet then i will be willing to move it onto one sheet.
    Reply With QuoteRegister To Reply
  17. 06-30-2015, 02:46 PM #17
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: How to pull multiple dates under one customer name

    Hi Webber,

    I haven't yet figured out what needs to be done - is the sheet1 to be used as a repository for the QMC # PN to be included.

    Can you take me through an entry to sheet1?? I'm confused
    Reply With QuoteRegister To Reply
  18. 06-30-2015, 03:07 PM #18
    webber15
    webber15 is offline
    Registered User
    Join Date
    06-23-2015
    Location
    michigan US
    MS-Off Ver
    2010
    Posts
    34

    Re: How to pull multiple dates under one customer name

    Okay lets see if this helps.
    So after i run my report each I will save it as a separate excel doc under that date. from there i will copy from that date's work book go into my running report and paste it into that days sheet (ie. 'tuesday' sheet) in the running example. from there i use v look up to pull in the shipment date from each day sheet through look up of the qmc# pn.
    Reply With QuoteRegister To Reply
  19. 06-30-2015, 05:45 PM #19
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: How to pull multiple dates under one customer name

    Tell me about sheet1 - I'm assuming that inserting rows is no longer required or desired - are we to add to those entries? f.r. where do the on hand figures come from? I'm having so much trouble grasping your requirements that I'm considering starting a thread for other contributors to render aid (we have a "Call in the Cavalry" thread for these situations)??
    Reply With QuoteRegister To Reply
  20. 07-01-2015, 08:12 AM #20
    webber15
    webber15 is offline
    Registered User
    Join Date
    06-23-2015
    Location
    michigan US
    MS-Off Ver
    2010
    Posts
    34

    Re: How to pull multiple dates under one customer name

    This is mainly my fault i am sorry i am just not sure what information to give you.
    Here is the vlookup formula that i use for the quantity ;
    =IF(ISERROR(VLOOKUP(A3,FRI!$A$1:$G$607,5,FALSE)),"", VLOOKUP(A3,FRI!$A$1:$G$607,5,FALSE))
    and this one for the date
    =IF(ISERROR(VLOOKUP(A3,FRI!$A$1:$G$607,7,FALSE)),"", VLOOKUP(A3,FRI!$A$1:$G$607,7,FALSE))
    .
    if it is possible i would like to add additional rows if there is additional dates beyond the first one the shows up. If i have to add the lines individually because of the number of sheets it is cross referencing i can do that instead.
    Reply With QuoteRegister To Reply
  21. 07-01-2015, 08:15 AM #21
    webber15
    webber15 is offline
    Registered User
    Join Date
    06-23-2015
    Location
    michigan US
    MS-Off Ver
    2010
    Posts
    34

    Re: How to pull multiple dates under one customer name

    i simply want to be able to (pull, lookup, find,show) more than just the nearest date. If there is a way that a formula can add in the rows that would be great.
    Please let me know what part of my explanation is confusing or hard to understand and i will try to clarify
    Reply With QuoteRegister To Reply
  22. 07-01-2015, 04:30 PM #22
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: How to pull multiple dates under one customer name

    I've run the newest version and gotten no result - tell me, should there be entries generated from this dataset and, if so, what should they be - just one entry can get me rolling again

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  23. 07-01-2015, 04:53 PM #23
    webber15
    webber15 is offline
    Registered User
    Join Date
    06-23-2015
    Location
    michigan US
    MS-Off Ver
    2010
    Posts
    34

    Re: How to pull multiple dates under one customer name

    Okay so for 140882 i would like it to add an additional line, if it is found that there is more than one date. There for Thursday i would like it too add an additional line and generate the entire of 56 on 7/13/2015 on the second line.
    In the attached on sheet 2 i have only 140882 part number, on the sheet 3 i have what i am expecting to get.fORUM EXAMPLE2.0.xlsx
    Reply With QuoteRegister To Reply
  24. 07-04-2015, 03:04 PM #24
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: How to pull multiple dates under one customer name

    Data Range
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    P
    Q
    R
    S
    T
    U
    V
    W
    X
    Y
    Z
    AA
    AB
    AC
    AD
    1
    QMC # PN
    PN
    ON HAND
    FRIDAY
    6/19/2015
    MONDAY
    6/22/2015
    QTY
    DAYS
    TUESDAY
    6/23/2015
    QTY
    DAYS
    WEDNESDAY
    6/24/2015
    QTY
    DAYS
    THURSDAY
    6/25/2015
    QTY
    DAYS
    FRIDAY
    6/26/2015
    QTY
    DAYS
    2
    3
    140882-00FP
    FC44 4831 NFGA
    77
    24
    6/23/2015
    24
    6/23/2015
    24
    6/23/2015
    20
    6/25/2015
    Change
    20
    6/25/2015
    56
    7/13/2015
    Change
    -36
    18
    4
    44
    7/20/2015
    68
    7/27/2015

    Data Range
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    P
    Q
    R
    S
    T
    U
    V
    W
    X
    Y
    Z
    AA
    AB
    AC
    AD
    1
    QMC # PN
    PN
    ON HAND
    FRIDAY
    6/19/2015
    MONDAY
    6/22/2015
    QTY
    DAYS
    TUESDAY
    6/23/2015
    QTY
    DAYS
    WEDNESDAY
    6/24/2015
    QTY
    DAYS
    THURSDAY
    6/25/2015
    QTY
    DAYS
    FRIDAY
    6/26/2015
    QTY
    DAYS
    2
    3
    140882-00FP
    FC44 4831 NFGA
    77
    24
    6/23/2015
    24
    6/23/2015
    24
    6/23/2015
    20
    6/25/2015
    Change
    20
    6/25/2015
    56
    7/13/2015
    Change
    -36
    18
    4
    44
    7/20/2015
    68
    7/27/2015

    ????????????
    Last edited by xladept; 07-04-2015 at 03:09 PM.
    Reply With QuoteRegister To Reply
  25. 07-04-2015, 04:19 PM #25
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: How to pull multiple dates under one customer name

    Data Range
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    P
    Q
    R
    S
    T
    U
    V
    W
    X
    Y
    Z
    AA
    AB
    AC
    AD
    1
    QMC # PN
    PN
    ON HAND
    FRIDAY
    6/19/2015
    MONDAY
    6/22/2015
    QTY
    DAYS
    TUESDAY
    6/23/2015
    QTY
    DAYS
    WEDNESDAY
    6/24/2015
    QTY
    DAYS
    THURSDAY
    6/25/2015
    QTY
    DAYS
    FRIDAY
    6/26/2015
    QTY
    DAYS
    2
    3
    140882-00FP
    FC44 4831 NFGA
    77
    24
    6/23/2015
    24
    6/23/2015
    24
    6/23/2015
    24
    6/23/2015
    16
    6/25/2015
    20
    6/25/2015
    Change
    -36
    18
    4
    76
    7/13/2015
    56
    7/13/2015
    44
    7/20/2015
    48
    7/20/2015
    68
    7/27/2015
    5
    80
    7/27/2015

    ????????????????????
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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. i need to pull information from two columns and end of up with a customer number, VBA?
    By nate02167 in forum Excel Programming / VBA / Macros
    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. How to pull transactions into a template based on a customer code?
    By The_Snook in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1