+ Reply to Thread
Results 1 to 12 of 12

Taking Information from Master Sheet and Placing it on several Sub-sheets

  1. #1
    Registered User
    Join Date
    06-11-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    7

    Taking Information from Master Sheet and Placing it on several Sub-sheets

    I have a master sheet that looks like the following attached sample. I want to take the classes that students have enrolled and automatically generated separate attendance sheets for each class they enrolled in. For example; I want to pull all the students signed up for pottery onto a separate sheet that lists only those students who selected pottery. I am not well versed in Excel so I would appreciate all the counsel I can get.
    Attached Files Attached Files
    Last edited by gbliss; 06-11-2013 at 01:40 PM.

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Taking Information from Master Sheet and Placing it on several Sub-sheets

    A macro code will do, but there is no attached.

  3. #3
    Registered User
    Join Date
    06-11-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Taking Information from Master Sheet and Placing it on several Sub-sheets

    I don't know why it did not attach.
    This is what it looks like.

    Last Name First Name Class 1 Class 2 Class 3
    Smith John Pottery Music Cooking
    Smith Amy Gym Pottery Drawing
    Thompson John Math Pottery Auto Shop

    I want the subsequent pages to be all the kids in pottery on one page...etc.

  4. #4
    Registered User
    Join Date
    06-11-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Taking Information from Master Sheet and Placing it on several Sub-sheets

    There, I think I have it attached now.

  5. #5
    Registered User
    Join Date
    06-11-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Taking Information from Master Sheet and Placing it on several Sub-sheets

    I think I have the attachment on there now.

  6. #6
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Taking Information from Master Sheet and Placing it on several Sub-sheets

    Okay! Are the classes be in columns C-G?

  7. #7
    Registered User
    Join Date
    06-11-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Taking Information from Master Sheet and Placing it on several Sub-sheets

    Yes, they are in those columns.

  8. #8
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Taking Information from Master Sheet and Placing it on several Sub-sheets

    There is a button on sheet1. When you run it, it will clears existing data and re-populate all sheets with new data.
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    06-11-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Taking Information from Master Sheet and Placing it on several Sub-sheets

    That is exactly what I want, but how did you do it?

  10. #10
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Taking Information from Master Sheet and Placing it on several Sub-sheets

    gbliss,
    It is a macro code. I do not know if you want to go in to the deep end of macro. I thought myself in this site. The best place to start learning macro is by recording what ever you want to do and look at what excel produces and learn each line.
    Macro includes lots of line which you may not include them if you code it yourself, but a good starting point.

  11. #11
    Registered User
    Join Date
    06-11-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Taking Information from Master Sheet and Placing it on several Sub-sheets

    You have been awesome. Thank you so much. I had 127 students last semester and I was hand moving all the kids to the separate sheets. When you consider I had over 55 classes, you can imagine the time consuming task it was. Again, thank you very much.

  12. #12
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,289

    Re: Taking Information from Master Sheet and Placing it on several Sub-sheets

    With a filter you can keep everything in one sheet.
    Choose a task in A1 en see what happend.
    Attached Files Attached Files
    Last edited by popipipo; 06-11-2013 at 03:09 PM. Reason: updat file
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1