All Questions
4 questions
0
votes
1
answer
475
views
Create a new Pivot TableStyle
I recorded a macro to create a new Pivot Table style so whenever I create a new worksheet, this Pivot Table Style is added as the default for the Workbook.
It does not work when I try to run it on a ...
0
votes
0
answers
126
views
VBA Pivot Table code working when stepped through, but not when assigned to a Macro Button
My code that formats certain rows on my pivot table works when I step through the code, step by step. However, when I assigned the macro to a button, with other macros, it didn't complete the ...
- 1
1
vote
2
answers
958
views
EXCEL: Format cells based on style of adjacent Pivot Table
I'm trying to develop a report which is largely Pivot Table but with some adjacent cells for some other (non pivot-table-able) text values.
Each week the Pivot Table will be refreshed and rows with ...
- 319
1
vote
1
answer
1k
views
Excel Pivot Table - Formatting and Grouping Columns with Dates and Another Column
I have worked with basic pivot tables for a few years, however I am getting stuck on something that I think should be fairly simple to solve (ugh).
I would like to format my pivot table in a ...
- 43