Breaking up one sheet into multiple sheets by a row identifier

[dubdub]

hi all,

is there an easy way to break up one sheet into multiple sheets by a row identifier.

TIA.

[sdckapr]

I leave it to you to define "easy".

Manually you can filter on the "row identifier" and copy the visible rows to a new sheet, but a macro can be created (there have been example code posted on this board)

I am not a proponent of breaking up 1 worksheet into multiple subsets. Once can create the same effect with a filter, but with one sheet it makes it so much easier to work with the data and summarize using subtotals or even a pivot table and chart.

Steve

[dubdub]

Thanks Steve,

agree, my intention here is to segment the sheet to enable sending each segment to it's relevant group. appreciate any guidance to such code.

dubdub

[sdckapr]

There is some example code which should be adaptable at:
http://windowssecrets.com/forums/sho...ol-A-(2000-SP3)
http://windowssecrets.com/forums/sho...heet-(2002-SP3)

Test on a copy of the worksheet!

Steve
PS here is another one that may be useful. It prints out each selection from a autofilter list. It could be adopted to saving it to a new workbook or new worksheet in the workbook if you are doing it based on an autofilter.
http://windowssecrets.com/forums/sho...lter-list-(All)

[dubdub]

Many thanks Steve for your attention. It really gives the feeling you work with a family member.