E
eeelllaaa
Hi,
maybe someone could help me - I have a pivot table which source data changes
very often.
It's something like this:
----------------------------------------
| city1 | city2 |
------------------------------
| item1 | item2| item3 | item4|
----------------------------------------
names .. .. .. .
Cities are often the same, but number of items can be different, depends of
period. The headers of table have to be coloured (only headers, not cells wi
th data), for example: "city1" and it's "items" should be blue, and "city2"
and it's "item" -yellow. But when the source data change and there are some
new items, the headers are not formatted.
I would like to do this automatically, with some macro. What properties or m
ethods of PivotTable should I use?
Thanks,
Ela
maybe someone could help me - I have a pivot table which source data changes
very often.
It's something like this:
----------------------------------------
| city1 | city2 |
------------------------------
| item1 | item2| item3 | item4|
----------------------------------------
names .. .. .. .
Cities are often the same, but number of items can be different, depends of
period. The headers of table have to be coloured (only headers, not cells wi
th data), for example: "city1" and it's "items" should be blue, and "city2"
and it's "item" -yellow. But when the source data change and there are some
new items, the headers are not formatted.
I would like to do this automatically, with some macro. What properties or m
ethods of PivotTable should I use?
Thanks,
Ela