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

    Nov 24, 2010
    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

    Oct 24, 2008
    Tilchestune UK
  3. cubbywhale thread starter macrumors newbie

    Nov 24, 2010
    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