reza_doang
09-04-2010, 11:41 PM
Hi All,
i create data entry from column A - D, then i drag column A to Row Labels and Column D to Values. then i will have pivot table.
and when i double click in values, it will create a new table in a new worksheet for that labels.
now, when i double click and create new worksheet, can that worksheet automatically have a name like labels.
i.e
row labels count
BUS 100
TAXI 150
AIR PLANE 60
and when i double click in 100, then create a new worksheet with name BUS...and so on...
can someone provide me a vba to achieve that.
i also attach my sample.(this is only sample, my column more than 4 col)
many thanks
reza
i create data entry from column A - D, then i drag column A to Row Labels and Column D to Values. then i will have pivot table.
and when i double click in values, it will create a new table in a new worksheet for that labels.
now, when i double click and create new worksheet, can that worksheet automatically have a name like labels.
i.e
row labels count
BUS 100
TAXI 150
AIR PLANE 60
and when i double click in 100, then create a new worksheet with name BUS...and so on...
can someone provide me a vba to achieve that.
i also attach my sample.(this is only sample, my column more than 4 col)
many thanks
reza