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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AUTOMATICALLY REFERENCE SALES INFO FROM WORKSHEET #1 INTO INDIVID. 1
Combining Worksheets 1
Linking Data from 1 worksheet to another by using dates? 1
Working out VAT owed 1
Linking Sales Order to Sales History Data 6
Go to a chosen worksheet 1
Combine 6 Worksheets to 1 Worksheet with total amounts 2
How to sum by month 8

Back
Top