Populate a table based on single selection

Discussion in 'Mac Apps and Mac App Store' started by cubbywhale, Nov 24, 2010.

  1. cubbywhale macrumors newbie

    Joined:
    Nov 24, 2010
    #1
    Hello all,

    I'm using Numbers 08, and I'm trying to set up an invoice/hours tracker for my business. I'm trying to figure out if the following is possible:

    On one sheet I have a table with Date, Description, Hours and Invoice # as column headers. Each day's work is recorded, and an invoice # assigned for dates falling within each billing cycle. This part is done manually, and that's fine.

    On a second sheet I have an invoice to send to the customer. What I would like to do is input the invoice # in a cell at the top of the form, and have a table below self-populate with all of the relevant data from matching entries on the first sheet. The list would need to be of a flexible length, since some invoices may have more or less entries than others...

    Any help would be greatly appreciated! Thanks!
     
  2. Lordedmond macrumors regular

    Joined:
    Oct 24, 2008
    Location:
    Tilchestune UK
    #2
  3. cubbywhale thread starter macrumors newbie

    Joined:
    Nov 24, 2010
    #3
    Wow. That response has absolutely nothing to do with what I was asking. At all. Was I really that unclear?

    Anyone else?
     

Share This Page