Continuous sales are being recorded on one worksheet (date, customer,
product, salesman, dollar amount, delivery date, etc.) I want to
automatically have these copied to individual customer worksheets with same
total information in preparation for account analysis.

Hi
try:
http://www.rondebruin.nl/copy5.htm#all

--
Regards
Frank Kabel
Frankfurt, Germany

"GeorgeF." schrieb im Newsbeitrag
...
Continuous sales are being recorded on one worksheet (date, customer,
product, salesman, dollar amount, delivery date, etc.) I want to
automatically have these copied to individual customer worksheets
with same
total information in preparation for account analysis.

You could also consider this:

Instead of having a separate worksheet for each customer, you could just
filter your data table on the customer field and use the SUBTOTAL function
to summarize data in visible cells only.

Carlos

"GeorgeF." wrote in message
...
Continuous sales are being recorded on one worksheet (date, customer,
product, salesman, dollar amount, delivery date, etc.) I want to
automatically have these copied to individual customer worksheets with
same
total information in preparation for account analysis.