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
Bookmarks