Building a summary page

Giganews Newsgroups
Subject: Building a summary page
Posted by:  jackso…@hotmail.com (jackso…@hotmail.com)
Date: Fri, 6 Mar 2009

Example:

Vendor    Sales    Cost

Sheet1: Walk-in sales
abc    1.00    .50
def    1.00    .50
ghi    1.00    .50

Sheet2:    Drive-thru sales
abc    1.00    .50
ggg    1.00    .75
ghi    1.00    .50

Sheet3: Mailorder sales
ggg    1.00    .45
klm    2.00    .80
frt    1.00    .90

How can I build a summary page as follows:

Total Sales:
abc    2.00    1.00
def    1.00    .50
ghi    2.00    1.00
ggg    2.00    1.20
klm    2.00    .80
frt    1.00    .90

Replies