How to populate an invoice table from the bottom up with only services having associated costs from another Numbers table?
Im looking to have 2 tables. The first table will be a table that allows for costs to be entered, altered or deleted as necessary, and then have those services and associated costs transferred to another table that will populate from the BOTTOM UP with only those services containing a cost associated with them. Likewise, if a cost is added or subtracted, those changes should reflect in the invoice table below.
Is this possible without using an AppleScript? I'm fairly certain I could get it to work with a script, but I'm having a difficult time with the having Numbers exclude items in the Invoice Listing that don't have a cost. I also know filtering will work, but the trouble with filtering is the table collapses from the bottom up and not the top down. Im basically looking to filter the services with a cost without using a filter.
I'm calling on all Apple Numbers Gurus that might be able to help me with this. Much thanks in advance!
[Edited by Moderator]
Original Title: Fill A Table From The Bottom Up With Only Specific Items Having An Associated Cost that Have Been Entered In Another Table