BasicElement
New Member
- Joined
- May 25, 2009
- Messages
- 4
Hi everyone !<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
I really need your help on this one and would really appreciate any suggestions you may have for me !<o></o>
<o> </o>
The thing is that I have an Excel Workbook with Raw Data, a big PivotTable, based on it and finally a few nice looking Graphs.<o></o>
<o> </o>
I have a "Selection" sheet, with ActiveX CheckBoxes for each week of the year. I want to be able to change the PivotTable selections, based on the selected CheckBoxes.<o></o>
<o> </o>
For example:<o></o>
If a user selects 3 CheckBoxes ("w1", "w5" and "w10"), there should be a macro, assigned to a button, which changes the "Week" selection in PivotTable1.<o></o>
<o> </o>
I hope you can help me solve this one and thank you in advance for your time !<o></o>
<o> </o>
<o> </o>
Best regards,<o></o>
Victor<o></o>
<o> </o>
I really need your help on this one and would really appreciate any suggestions you may have for me !<o></o>
<o> </o>
The thing is that I have an Excel Workbook with Raw Data, a big PivotTable, based on it and finally a few nice looking Graphs.<o></o>
<o> </o>
I have a "Selection" sheet, with ActiveX CheckBoxes for each week of the year. I want to be able to change the PivotTable selections, based on the selected CheckBoxes.<o></o>
<o> </o>
For example:<o></o>
If a user selects 3 CheckBoxes ("w1", "w5" and "w10"), there should be a macro, assigned to a button, which changes the "Week" selection in PivotTable1.<o></o>
<o> </o>
I hope you can help me solve this one and thank you in advance for your time !<o></o>
<o> </o>
<o> </o>
Best regards,<o></o>
Victor<o></o>