I have this:

A B C
Carl 001 $8.0
Carl 189 $1.5
JOHN 189 $1.5

TOTAL Carl 190 $9.5
JOHN 189 $1.5

I want to have a new sheet where I can insert just the result like this:


JOHN
B 189
c 1.5

Carl
B 190
C 9.5


Now I have 400 differents name, is not just JOHN or Carl, there is a way of
doing it automatically sort by name get a total and insert on the new sheet
and also in one sheet so I select from the sheet the name and it change the
results?
Thank you

Try the advanced filter tool. http://www.contextures.com/xladvfilter01.html



"HERNAN" wrote:

I have this:

A B C
Carl 001 $8.0
Carl 189 $1.5
JOHN 189 $1.5

TOTAL Carl 190 $9.5
JOHN 189 $1.5

I want to have a new sheet where I can insert just the result like this:


JOHN
B 189
c 1.5

Carl
B 190
C 9.5


Now I have 400 differents name, is not just JOHN or Carl, there is a way of
doing it automatically sort by name get a total and insert on the new sheet
and also in one sheet so I select from the sheet the name and it change the
results?
Thank you