Can Sales Listing from Worksheet #1 go to individual worksheets?

G

GeorgeF.

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.
 
C

CarlosAntenna

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
 
Top