Hi,

You've not post much info. This link might help.

http://www.contextures.com/xlPivot10.html

If not what your after then ost an example of data with expected results

VBA Noob