Excel report

Winndixie Posts 23 Registration date Monday March 10, 2014 Status Member Last seen September 28, 2018 - Sep 13, 2014 at 08:52 AM

I create a seller report

Worksheet 1--- I named it as Price list ... is a Data for my seller report that I set a code, name, points and amount

worksheet 2-5--- I named by sellers name which is individual selling report by the seller, then it mind be including other seller name too.

the last worksheet--- I named it summary for my reporting. in this report I differentiation by seller name. I need to report individual total actual selling by the seller

I wonder how do I set when my seller worksheet that which name Pauline, in her selling report got including another seller name Carmen, then my summary will auto show the selling under Carmen selling.

sample file : http://speedy.sh/Zr5bX/Sample.xlsx