You can set it to refresh on open under table options, otherwise you need to
either use VBA or right click and select refresh.

--


Regards,


Peo Sjoblom


"Strimkind" wrote in message
...
Thank you, that worked well...will the table update automatically or do I
have to do it manually?

"mr tom" wrote:

Yep.

Use a pivot table.

Select the cells you want to review. Click Data, Pivot Table Report.

Run through the wizard, putting your range of cells as both the row
element
and the data element. If it puts SUM in the data element, change it to
COUNT. Click finish.