I have a pivot table that contains several groups.

100101
100102
100103
...
200101
200102
200103
...

The entries above are numbers in column B of the sheet that the Pivo
Table extracts data from. The entries above are not unique - ther
could be many instances of each. In the Pivot table I manually grou
together these entries according to the first three digits.

For example, 100101, 100102, 100103, and any other number beginnin
with 100... would be grouped together and given the group name 100. Th
same would be so for any other group of numbers that shared the firs
three digits.

The problem that I'm having, however, is when I add new data to th
worksheet and refresh the Pivot Table. If the new entry contains
number in column B that matches one of the existing numbers in th
Pivot Table, then the data is successfully added to the right group
However, if the 6 digit number in column B is a new one (i.e. doesn'
yet exist in the Pivot Table), then this entry will not be grouped. I
appears at the bottom of the table.

HERE IS MY QUESTION: Is there a way to make the Pivot Table recogniz
the first three digits of the number in column B and then add the ne
number to the group that contains all the other 6 digit numbers wit
the same first three digits?

Thanks in advance for any help

--
Spreadshee
-----------------------------------------------------------------------
Spreadsheet's Profile: http://www.excelforum.com/member.php...fo&userid=3473
View this thread: http://www.excelforum.com/showthread.php?threadid=55422