How can I make excel break multiple rows into new sheets without doing it manually?
November 13, 2012 9:44 AM Subscribe
How can I make excel break each common row off into a new sheet?
posted by Calicatt to computers & internet (10 answers total) 1 user marked this as a favorite
My google-fu doth fail me.
I have an excel sheet which is something like this
How do I get Excel to break the categories into seperate sheets without doing in manually (it's a very long list)?
Bonus Points: There are some things which are similar but not exactly the same which should stay together--ex. BANANAS, BANANAS1--is there any way to keep them together on a new sheet?