On Sheet1, I have a number of categories all with running totals. On Sheet2 I have some of the same categories. I want to continue the running total on Sheet2, but need to know how to return the running total (largest value in each category) from Sheet1.

e.g.

Sheet 1
Column N Column AL
Apples 1
Apples 4
Apples 6
Oranges 2
Oranges 4
Oranges 9
...

Sheet 2
Column N Column AL (want)
Apples 6
Apples
Apples
Apples
Oranges 9
Oranges
Oranges

Thanks for any help!


BD