Manipulating Pivot table groups.

Hi guys,
I have created a pivot table which hide some items and group others in 5 different groups.
The problem I am having is that when of the pivot items is missing from the data or there is item in excess from what I had programed the table doesn't work properly.

'Select which Items will be visible in order to group them by selecting range.

Please Login or Register  to view this content.

'I have about 53 items (as above) that are grouped into 5 groups.
I wont put them all here because i think this would be too big a post.

'############################
' Group Items into categories
'############################

'

Please Login or Register  to view this content.

I do the same for the 5 groups, basically the way they are grouped is by first organizing them into positions and then i select the colums and group

So far I have created a "blank data set where it has 1 example of all the transactions in my full data bank, so my data will always have at least one transaction per type of transaction and my pivot table macro will work.

However, when a new type of transaction that I havent programmed appears in my data the method of groupin the data by range will not work as there will be more ranges than i programmed for.

If a item type is available I would like to set it invisible.

Is there a way of grouping the items by their names and even when a type of item is not present the table will still run?


Below the full code if you are interested.

Please Login or Register  to view this content.

Sorry for the mess. if anybody didn't understand please let me know.