Pivot table - Auto Formating Data in the Source Data Sheet

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
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

arunjhalani

Board Regular
Joined
Oct 8, 2002
Messages
121
1.0 Assuming the the Target Sheet is the Pivot Report, U can use the optionds menu of Pivot Table and deselect the Autoformat options, then the Fprmat u saved for Pivot will be valid for the Diff combinations u'r User Generates
2.0 Point no. 2 Suggests that u are double Clicking the Grand Total, which populates the whole input data. if that is the case, then First option Doesnt HElp & u need to write a macro for that. may be other Board members can help for that

Regards

Arun Jhalani
SAP CO Consultant
 

Rajagopalan VK

New Member
Joined
Dec 22, 2005
Messages
8
Re: Auto Formating Data in the Source Data Sheet

1.0 Assuming the the Target Sheet is the Pivot Report, U can use the optionds menu of Pivot Table and deselect the Autoformat options, then the Fprmat u saved for Pivot will be valid for the Diff combinations u'r User Generates

Re: If the user disables the Auto Format option in the Pivot table, the pivot table is set back to the initial state or font and color it was previously present in. I f iam wrong guess i would need more insight on the comment, as i have been working not much but only the basic function in excel.. :(

2.0 Point no. 2 Suggests that u are double Clicking the Grand Total, which populates the whole input data. if that is the case, then First option Doesnt HElp & u need to write a macro for that. may be other Board members can help for that

Re: That is true. On trying the same, i am faced with a complex arrayof merging and cell formating, which me with no idea of VB Programming dont have a clue as to how to achieve. :(

Thanks a lot. Please let me know how to do it, as it would enhance the productivity of the test case generator.
:(
 

Watch MrExcel Video

Forum statistics

Threads
1,119,002
Messages
5,575,483
Members
412,668
Latest member
Lukep22
Top