creating new spreadsheets

[Robey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

A have a workbook with Columns A-N. 19000 lines. The worksheet is sorted by column a (titled "Region")first, then by column b (titled "facility"). There are 400 facilities. I'd like to breakout and create individual worksheet(s) for each of the facilities. Then I'd like to email out the individual worksheets. Is there an easy way to do this? Thanks in advance

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

A have a workbook with Columns A-N. 19000 lines. The worksheet is sorted by
column a (titled "Region")first, then by column b (titled "facility"). There
are 400 facilities. I'd like to breakout and create individual worksheet(s)
for each of the facilities. Then I'd like to email out the individual
worksheets. Is there an easy way to do this? Thanks in advance

Easy way? Not without macro code. But, have you tried subtotals? This will
organize the sheet the way you want. You can then hide rows and protect the
sheet, or copy and past groups of rows to a new sheet for distribution.