Hi,

I have a workbook with 30 - 40 sheets. Each of these sheets are use
for seperate customers and contain rows of orders. After each orde
type there is a Totals row.

I would like to be able to take a copy all of the different Totals row
(and the customer name) to a master sheet.

e.g.

Sheet: Customer One

Product Customer Price Weight
1 Customer One 3 12
1 Customer One 3 8
1 Customer One 3 10
1 Customer One 3 15
12 45


2 Customer One 9 2
2 Customer One 9 5
2 Customer One 9 7
2 Customer One 9 11
2 Customer One 9 5
45 30

Therefore, copy the two Totals rows into 'Totals' worksheet appearin
as below

1 Customer One 12 45
2 Customer One 45 30


thanks in advance
Hamis

--
Message posted from http://www.ExcelForum.com