J
Jay Gustafson
Hello,
I had first placed a post to this group which I did receive a response, but there would be a few problems with that suggestion, so I'm going to explain this in more detail.
Every day, I sent up a report that uses several pivot tables / configurations based on the same file of information. Setting up the pivot table is very easy to do so manually. There are several fields that require me to check & uncheck certain items within those fields. The majority of fields only require me to check or uncheck a couple in each one. But I have two fields that have many (50+) employee names in them.
I need a macro in place that would speed up the procress of checking & unchecking specific names within those fields. I have no experience in working with code, except cut & paste. I am using Excel 2000, inwhich all the items in a field are automatically checked. Could someone write me up a code that would uncheck all items within any field I have in the pivot table?
Atleast that way, if when I set up the pivot table, then run the macro to unselect every item in all fields, then I can record macros to select the items I DO want. These fields change all the time, so as the time passes, I can edit the code & add or remove a name as it will only be coping and pasting the code.
Can someone help me?
I had first placed a post to this group which I did receive a response, but there would be a few problems with that suggestion, so I'm going to explain this in more detail.
Every day, I sent up a report that uses several pivot tables / configurations based on the same file of information. Setting up the pivot table is very easy to do so manually. There are several fields that require me to check & uncheck certain items within those fields. The majority of fields only require me to check or uncheck a couple in each one. But I have two fields that have many (50+) employee names in them.
I need a macro in place that would speed up the procress of checking & unchecking specific names within those fields. I have no experience in working with code, except cut & paste. I am using Excel 2000, inwhich all the items in a field are automatically checked. Could someone write me up a code that would uncheck all items within any field I have in the pivot table?
Atleast that way, if when I set up the pivot table, then run the macro to unselect every item in all fields, then I can record macros to select the items I DO want. These fields change all the time, so as the time passes, I can edit the code & add or remove a name as it will only be coping and pasting the code.
Can someone help me?