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