Hi Pat

Whilst on the sheet with the source data
InsertNameDefine enter a name for the data range in the Name box fill in
the formula given in the Refers to box

--
Regards
Roger Govier

"PatJennings" wrote in message
...
Than you Roger, however, I am using 2002, and unfortunately I am having
difficulty creating the name for the data. Do I select the worksheet, or
the rows of existing data, or something else? Is relevant where the
cursor is when creating the name? My pivot tables are on separate
worksheets.
Pat

"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi Pat
When that data is entered, will I have to change the range of data, or
will it automatically include the new entries?

The simple answer is No.
However, you can make the data source range grow automatically as you add
more data.
Depending upon your version of Excel, you may have an inbuilt method to
achieve this.
With XL2003 place cursor in your source data rangeDataListCreate List
With XL2007 again place cursor in data rangeInsert tabTable

In each case, if you then right click on the PTBackenter the name of
the table in the source dialogue =Table1, or whatever it is called, then
the PT will automatically include all new data when you Refresh the PT.

If your version is earlier than XL2003 (this also works with 2003 and
2007) you can create a dynamic range.
Insertnamedefine Name myData Refers to
=$A$1:INDEX($1:$65536,COUNTA($A:$A),COUNTA($1:$1))

The above formula is a general formula that will work for all situations
assuming you have no entries in row 1 beyond the data you want to Pivot,
and that your header starts in A1.

If your data only went to say column H, then you could simplify the range
to something like
=$A$1:INDEX(H:H,COUNTA(A:A))
(I am assuming that column A will always be populated if there is a row
of data in the table.)

Again in the PT wizard, give source as =myData

Can I create at the end of the table, or outside of it totals for the
monthly transactions by state?
You can, but why not create them within the PT?
Drag State to the Row area, and place it above Name.
You will then have a count of Name, within State, and a Subtotal for the
State. If Subtotal is not showing, double click State on the PT and
choose Subtotal Automatic
--
Regards
Roger Govier

"PatJennings" wrote in message
...
Thanks Roger, your solution worked.

If I may ask additional Questions:

I have two columns indicating the last name and state of the
individuals. The count of months are currently for Jun, Jul and Aug.
There will be additional transactions for Sep, etc.

When that data is entered, will I have to change the range of data, or
will it automatically include the new entries?

Can I create at the end of the table, or outside of it totals for the
monthly transactions by state? (It already gives me the totals for the
person's name by month.

Sincerely,
Pat