Help Creating a new Worksheet

[macourtney1]

Good Morning. I am a BASIC/BEGINNER excel user, no VBA/MACRO experience. I have a workbook that contains a master sheet of members who may be participating in various (and multiple) activities. I want to create a worksheet for each of the activities that automatically populates when a flag is set on the master list. For example, on the master list, the member name is in column a, and if the member participates in activity 1, there is a number 1 in column b. If they participate in activity 2, there is a number 1 in column 3 and so on. I want to have a worksheet that reads the master file and finds an occurence of a member with a 1 in the "given" activity column, then return the values from specific columns (containing demographic data) for that member. Then find the next member, and so on. I want it to automatically populate everytime the master sheet is updated. Any help with this would be greatly appreciated.

 

[ChrisM]

Your best bet is a pivot table, do you know how to use them?

If not a pivot table, without macros there's really not a way to just make names appear on all your various sheets. Each sheet would have to contain ALL names, then you could do some vlookups and only return data for the appropriate names that match that activity, but that's not what you want.

How about an autofilter? You wouldn't need one sheet for each activity, just set the filter on your main sheet to the desired activity and you would only see the appropriate names.