R
reza
Guys...
when we create pivot table and we double click in values fields, pivot will
create a new sheet including all data.
i.e
i have a table which contains:
Division Names Salary
i create pivot table and select for Row Labels is Division and for Values
is Sum of Salary. Then in pivot table i double click one of Salary then it
will create new sheet which contains data for that division.
what i want to achieve, when we double click that values and create a new
sheet, can excel automatically give names as same as division. if i double
click sum of salary for marketing division, then will create Marketing sheet.
hope you get what i want to do.
many thanks
when we create pivot table and we double click in values fields, pivot will
create a new sheet including all data.
i.e
i have a table which contains:
Division Names Salary
i create pivot table and select for Row Labels is Division and for Values
is Sum of Salary. Then in pivot table i double click one of Salary then it
will create new sheet which contains data for that division.
what i want to achieve, when we double click that values and create a new
sheet, can excel automatically give names as same as division. if i double
click sum of salary for marketing division, then will create Marketing sheet.
hope you get what i want to do.
many thanks