A newbie question I guess.

I'm writing code to pull data from a worksheet to a pivot table in Excel 2003 - so far so good. Basically, it's cost data organised by date and category. I've grouped the dates OK but I also need to do some grouping on the categories and I can't seem to find any information on how to do this programatically

Any pointers would be much appreciated.

Mal