Rajagopalan VK
New Member
- Joined
- Dec 22, 2005
- Messages
- 8
Friends,
I am using the pivot table to generate the Testcases for a Product based company. The Product is made up of same modules and the user needs to select from the combos in the pivot table for the target Test Cases to be generated in the seperate sheet (on selecting the grand summary)
For the purpose of the pivot table, i had created two additional columns with the filter values. Presenlty on selceting the grand total, the source data is listed in a new sheet with the formatting absent.
Questins
1) Is there an option present or macro to preserve the formating in the target sheet
2) And i need to delete the last two columns in the target test case sheet as it is not part of the required data.
Please let me know by mail also
rajagopalanv@jbsoftindia.com
Thanks in advance,
Rajagopalan VK
I am using the pivot table to generate the Testcases for a Product based company. The Product is made up of same modules and the user needs to select from the combos in the pivot table for the target Test Cases to be generated in the seperate sheet (on selecting the grand summary)
For the purpose of the pivot table, i had created two additional columns with the filter values. Presenlty on selceting the grand total, the source data is listed in a new sheet with the formatting absent.
Questins
1) Is there an option present or macro to preserve the formating in the target sheet
2) And i need to delete the last two columns in the target test case sheet as it is not part of the required data.
Please let me know by mail also
rajagopalanv@jbsoftindia.com
Thanks in advance,
Rajagopalan VK