View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GMc GMc is offline
external usenet poster
 
Posts: 8
Default 2007 Tables (Subtotal)

I'm using the 2007 tables and am at a loss as to how to deal with a
particular situation. Basically what i am trying to achieve is to have a
table that has 2 rows attached to a particular stock (to deal with different
payment dates) and a subtotal within a larger table that will consist of
multiple tables. Sample of the data is below.

COMPANY,DATE PAID,UNFRANKED,FRANKED,
NEWS 30/09/2008 $70.00
30/03/2008 $20.00
Total $20.00 $70.00

I can work out how to add to the table for a new stock, Copying and pasting
doesn't seem to copy the table (unless i include the heading of which i dont
want for every stock).
I may be approaching this wrong but am looking for any assistance.

Thanks,