How do I subtotal a range of data and export to a new workbook?

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

Guest

I worksheet of transactions (sometime several thousand) that I need to "break
out" by salesperson id (which is a column in the worksheet) rather than cut
and paste, I'd like to export the data to a separate workbook for each person
each time the salesperson id changes in the list.
 

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

Getting Text data using the Data - Subtotal feature 1
Calculating Differences between columns in a Pivot Table 3
How do I write a formula to obtain information from another spread 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Export cell data to closed workbook 7
How do you apply a print area to an entire workbook 1
Excel 2003 + export of data 7
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Back
Top