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!
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!