## Creating Tables From a Master Table?

279 Views 3 Replies Latest reply: Oct 29, 2012 10:31 PM by Barry
Calculating status...
Currently Being Moderated
Oct 28, 2012 3:35 PM

Hi all,

I am trying to create tables that are generated from a master table. The reason behind this is I want to easily be able to modify this master table and then be able to print a well laid out invoice without all the extraneous information. I'm not really explaining this well so here is an example.

My Master Table is on it's own sheet and has a categorized listing of products like so:

Fruit

Bananas, 5 units, \$1.00

Apples, 3 units, \$0.50

Peaches, 0 units, \$2.00

Grains

Oatmeal, 0 units, \$2.00

Vegetables

Lettuce, 4 units, \$2.00

Celery, 6 units, \$1.50

Carrots, 2 units, \$3.50

On a seperate invoice sheet I would have multiple tables laid out to print. It will have a summary table like this:

Summary

Fruit, Subtotal \$6.50

Vegetables, Subtotal \$24.00

Total \$30.50

and seperate tables for each category:

Fruit

Bananas, 5 units, \$1.00

Apples, 3 units, \$0.50

Subtotal \$6.50

Vegetables

Lettuce, 4 units, \$2.00

Celery, 6 units, \$1.50

Carrots, 2 units, \$3.50

Subtotal \$24.00

Notice it does not include the peaches or grains since I didn't actually sell any units of those.

Is this possible? Can anyone point me in the right direction? Thanks.

• Level 7 (29,095 points)
Currently Being Moderated
Oct 28, 2012 10:48 PM (in response to foxbot)

Most of this looks possible. The most obvious exception is not showing the separate table for grains when no grains are shown.

A table has a defined number of rows and columns. That number may be changed manually, but I know no way of either adding or removing rows (or columns) through the use of formulas. If you want to use separate tables for each of these, you will need to set up four separate tables, each with the number of columns needed and, assuming there is a possibility that any particular order may include all items in at least one category, each with as many rows as there are items in the category for that table.

If you are willing to forego separate tables on the Invoice, then an outcome similar to what you ask is likely possible.

In your example, you have listed the subtotals for each category in which there has been an order at the top of the page, then have repeated those subtotals in a second line in each separate table. Why?

Regards,

Barry

• Level 7 (29,095 points)
Currently Being Moderated
Oct 29, 2012 10:31 PM (in response to foxbot)

OK. Sounds doable. No time to take a look at it tonight, but I should be able to get to it tomorrow evening.

Regards,

Barry

#### More Like This

• Retrieving data ...

#### Legend

• This solved my question - 10 points
• This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.