Hello-

I'm pretty new at this.

I have a pivot table.
Question 1: If I "format" my table, just the way I like it, is there a way
to "freeze" the format and just update the data? Without losing the font,
width, etc.

Question 2: In column X, I would like to take the data from Column A "Hats",
look at another worksheet named RawData, count how many occurances of "Hats"
there are in this file and put the results in column X. In column Y, I would
like the count of RED Hats, in Z, the count of BLUE Hats, in AA, any other
not red or blue hat count.

I really appreciate all the help this group provides.
Thanks in advance.