Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Breaking up one sheet into multiple sheets by a row identifier

    hi all,

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


    TIA.
    TIA
    dubdub

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    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

  3. #3
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts
    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
    TIA
    dubdub

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    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)
    Last edited by sdckapr; 2012-01-08 at 13:18.

  5. #5
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Many thanks Steve for your attention. It really gives the feeling you work with a family member.
    TIA
    dubdub

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •