H
HamishM
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
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