I have a massive master sheet that I need to break down into multiple sheets
based on data. Here is what I have:
2: FIRST LAST BIRTHDAY PHONE ADDRESS CLASS
Then 230 rows of info. What I would like to do is take all the class 1,
class 2, class 3, up to class 20 info (First, Last, Birthday, Phone, Address)
to go to it's own worksheet in the same workbook automatically if possible.
I have tried a suggested macro and a non-array formula but it didn't work and
I just got more confused. I tried a macro from Ron de Bruin but all it did
was put me into an open file window. As a new user to Excel 2007 I'm not
exactly sure how to convert the formulas to work with my worksheet. I have
never written a macro, do not understand all the language. Is anyone able to
help me with this challenge? Please!