Creating separate workbooks based on filter

  • Thread starter Thread starter BerkshireGuy
  • Start date Start date
B

BerkshireGuy

I have a workbook that shows:

AgencyID AgentID OrderID DateOrdered - etc.

This workbook can contain 5,000 rows sometimes or sometimes 10,000.

I'd like to find existing code that steps through the workbook - and
creates separate workbooks based on critera. Critera could be one or
more fields.


The idea is be able to email individual workbooks containing that
persons data.

Thanks,
Brian
 
You must log in or register to reply here.

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

Split Workbook into Multiple Workbooks 5
Creating a workbook(s) based upon a cells value <--HELP please 3
Multi-Step Worksheet Export - HELP! 2
Filtering arrays 8
copy workbook to new workbook based on cell value 3
Separating a master file into many workbooks 2
run macro in another workbook - error 1004 7
Separate code from workbook?! 2

Back
Top