You dont say where the data comes from or how it gets into your
spreadsheet.

If it is in a database then you can use Pivot Table wizard step 1 of 3
to slect the radio button to get the data from an external data source.
That can directly from a database storing the information or from
another spreadsheet where you have stored the information.

In either case you do not have to redefine the data range .. it will
just get everything that is there that meets any criteria you have
entered in the 'get data' process.

Set the pivot table to refresh automatically when you open the
spreadsheet if you want.

regards..


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=525362