You're welcome! Thanks for letting me know that it helped.

marksince1984 wrote:
Debra Dalgleish Wrote:

I didn't open your file, but if you want to arrange the data fields
horizontally, drag the Data field button onto the cell that contains
the
word Total, as shown he

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






BRILLIANT!! Thanks for the help, just what i needed!




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html