Thanks for the idea. I have one problem though I share my Detail workbook
with several others and I saw that a Pivot Table cannot be updated while
sharing and you cannot share a workbook with links to another. I don't know
if VB would be an answer but I know nothing about VB.

Thank you for your advise.
Joe

"Roger Govier" wrote:

Hi Joe

Depending upon the layout of the data in your Detail sheet, you may well
be able to create your Summary by using a Pivot Table report.

Take a look at Debra Dalgleish's site for help on setting up Pivot
Tables
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/tiptech.html scroll to the section on Pivot
Tables

or for a video demonstration then look at Mike Alexander's site
http://www.datapigtechnologies.com/f...es/pivot1.html
--
Regards

Roger Govier


"Joe Gieder" wrote in message
...
Is it possible to do this, have two worksheets one with Summary data
and one
with Detail data have the Summary sheet constantly look at the Detail
sheet
and if there has been new data entered on the Detail sheet
automatically
enter it on the Summary sheet. I have sales orders that have many many
items
listed for each number (the sales order is unique and can listed a
hundred
times) them and I want the sales order numer to be entered one time on
the
Summary sheet and then count how many items there are for that sales
order
and put it on the Summary sheet.

TIA
Joe