+ Reply to Thread
Results 1 to 1 of 1

populating a list of items depending upon whether cells have values

  1. #1
    Registered User
    Join Date
    11-03-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2010
    Posts
    1

    populating a list of items depending upon whether cells have values

    I'm admittedly a bit of an Excel newb, so I apologise in advance if my questions are here have been asked and answered (which they probably are were I to know enough to know how to phrase a search).

    I've created a bit of a complex sheet for tracking customer information, sales and pay and timing done. It currently has 26 sheets within it, two per month and two for a yearly sum, one with the information and one to calculate things since I really can't do it very elegantly at present and don't want the info displayed poorly.

    A screenshot of some of the book
    example sheet.PNG

    What I would like to do is to track any carryovers from previous sheets that haven't been paid or delivered.. i.e. for Decembers sheet, I'd like it to have a dynamically updated list of unpaid or undelivered vehicles (on attached image, that would be lines 3 for delivered and missing pay, and line 4 for not yet delivered) for all months that still have any that are missing a delivery date or a paid date, and have the sale date and name populate into a list, or in the case of not paid to have the sale date, delivery date and name populate on the right hand side under Bonuses.

    The only solution I can come up with is an extremely inelegant list that wouldn't be dynamic listing any and all previous sheets cell #s i.e. January!K2:January!K30 on and up through November!K2:November!K30 for Decembers sheet.

    I do want it to display well, and I've yet to come up with a solution that doesn't look like an abortion.

    I do want it to have two lists there, one for unpaid and one for undelivered. anyone up to helping me figure out a way to create that?

    Thanks in advance,

    Jason

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: populating a list of items depending upon whether cells have values

    It would be better if you upload a sample workbook with some sample data on it.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

+ 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] Populating excel cells depending on what is chosen from a drop down list
    By seanzerd in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-19-2013, 05:39 AM
  2. Populating a list box with items from cell
    By HikariHitachi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-27-2013, 04:13 PM
  3. Userforms - Populating a List box with Some List Items already selected
    By chuckie200 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-25-2013, 07:06 AM
  4. How to count and group items in a list depending on size of list?
    By Simon Lloyd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-12-2006, 07:20 PM
  5. How to count items in a list and group depending on size of list?
    By Simon Lloyd in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-27-2006, 07:14 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