Automate moving groups of rows into new sheets?

%3CLINGO-SUB%20id%3D%22lingo-sub-1814146%22%20slang%3D%22en-US%22%3EAutomate%20moving%20groups%20of%20rows%20into%20new%20sheets%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1814146%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20am%20task%20with%20moving%20all%20similar%20rows%20to%20individual%20sheets%20within%20the%20same%20workbook.%20I've%20looked%20everywhere%2C%20written%20failed%20macros%2C%20and%20now%20I%20am%20asking%20for%20serious%20help.%20Considering%20the%20attached%2C%20is%20there%20a%20way%20to%20group%20all%20similar%20rows%20that%20have%20identical%20numbers%20and%20move%20them%20automatically%20to%20new%20sheets%20with%20the%20name%20sheet%20number%20as%20my%20sample%20numbers%3F%20In%20my%20real%20work%20there%20is%20more%20data%20than%20attached%2C%20but%20it's%20confidential%20so%20I%20didn't%20want%20to%20add%20that%20information.%20However%2C%20this%20is%20copied%20from%20my%20real%20work%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help.%3C%2FP%3E%3CP%3E-Suzann%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello,

I am task with moving all similar rows to individual sheets within the same workbook. I've looked everywhere, written failed macros, and now I am asking for serious help. Considering the attached, is there a way to group all similar rows that have identical numbers and move them automatically to new sheets with the name sheet number as my sample numbers? In my real work there is more data than attached, but it's confidential so I didn't want to add that information. However, this is copied from my real work problem.

 

Please help.

-Suzann

0 Replies