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