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!

A really easy way would be to run a pivot table on the data set, which is
actually, really small. You can drag the class ID into both the row and data
fields. Pick something like Count of Class ID, which will give you a pivot
table with Class ID and a count of records associated to each. Double click
on one of the numbers and a new worksheet will open with just the records
associated with that class ID
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"cdcam" wrote:

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!

Can you upload a sample file using a free filehost,
then post a link to it here?

For example, you could use this free filehost to upload:
http://www.freefilehosting.net/

Copy the "direct link" which is generated after you upload,
then paste it here

(Desensitize your sample as appropriate)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,000 Files:354 Subscribers:53
xdemechanik
---
"cdcam" wrote in message
...
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!

Here is the direct link:
http://www.freefilehosting.net/download/3k2f5
This is exactly what my sheet looks like minus 230 rows of info. I would
like each class to have it's own master without having to sort, cut, and copy
a million times over. It would also be great if it automatically updated.
So when a new person is entered on the master that info automatically goes to
the class master. You would be a life-saver if you can help me. With all
this data it takes way too much time to do it all manually. There is a total
of 24 classes. thank you so much for looking at it and taking the time to
help me!!!!

"Max" wrote:

Can you upload a sample file using a free filehost,
then post a link to it here?

For example, you could use this free filehost to upload:
http://www.freefilehosting.net/

Copy the "direct link" which is generated after you upload,
then paste it here

(Desensitize your sample as appropriate)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,000 Files:354 Subscribers:53
xdemechanik
---
"cdcam" wrote in message
...
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!

I still think a Pivot Table would be the easiest way to do this. It would
take you all of a minute to create the base pivot table, which will update
(you have to refresh it) when new students are added, but you'd have to
create new master class pages, which just involves doubleclicking the count
value.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"cdcam" wrote:

Here is the direct link:
http://www.freefilehosting.net/download/3k2f5
This is exactly what my sheet looks like minus 230 rows of info. I would
like each class to have it's own master without having to sort, cut, and copy
a million times over. It would also be great if it automatically updated.
So when a new person is entered on the master that info automatically goes to
the class master. You would be a life-saver if you can help me. With all
this data it takes way too much time to do it all manually. There is a total
of 24 classes. thank you so much for looking at it and taking the time to
help me!!!!

"Max" wrote:

Can you upload a sample file using a free filehost,
then post a link to it here?

For example, you could use this free filehost to upload:
http://www.freefilehosting.net/

Copy the "direct link" which is generated after you upload,
then paste it here

(Desensitize your sample as appropriate)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,000 Files:354 Subscribers:53
xdemechanik
---
"cdcam" wrote in message
...
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!

It is the easiest way upfront but my info is constantly changing and being
added to. So if there is a way to automate it everytime a new name is added
I need to try that first because it saves a lot of time in the long run. I
like the idea of the pivot table though if I can't make a macro or formula
work. Even if I don't use it for this list I have others I am also working
on that the pivot table will work awesome for!

Thank you for your advice! It is greatly appreciated!

"M Kan" wrote:

I still think a Pivot Table would be the easiest way to do this. It would
take you all of a minute to create the base pivot table, which will update
(you have to refresh it) when new students are added, but you'd have to
create new master class pages, which just involves doubleclicking the count
value.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"cdcam" wrote:

Here is the direct link:
http://www.freefilehosting.net/download/3k2f5
This is exactly what my sheet looks like minus 230 rows of info. I would
like each class to have it's own master without having to sort, cut, and copy
a million times over. It would also be great if it automatically updated.
So when a new person is entered on the master that info automatically goes to
the class master. You would be a life-saver if you can help me. With all
this data it takes way too much time to do it all manually. There is a total
of 24 classes. thank you so much for looking at it and taking the time to
help me!!!!

"Max" wrote:

Can you upload a sample file using a free filehost,
then post a link to it here?

For example, you could use this free filehost to upload:
http://www.freefilehosting.net/

Copy the "direct link" which is generated after you upload,
then paste it here

(Desensitize your sample as appropriate)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,000 Files:354 Subscribers:53
xdemechanik
---
"cdcam" wrote in message
...
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!

I'm using xl2003. Unable to read your .xlsx.
Can you re-upload another sample, saved as .xls?
Post the new link
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,200 Files:354 Subscribers:53
xdemechanik
---