Tuesday, September 3, 2013

yogi_Pull Member Data From Another Sheet Limiting Number Of Members To A Specified Maximum Value

                                          Google Spreadsheet   Post  #1356
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep 03, 2013
user pbi -- question by jackSlack (http://productforums.google.com/forum/?zx=glyp03sqk8a2#!mydiscussions/docs/Oa5dLpWBCiE)
Displaying a filtered sheet in a google site.
Yogi, this sounds very close to what I'm trying to do, could you go into some more detail?

I'm trying to create a weekly sign up sheet for a club. The idea is that I keep tabs on who is currently qualifying for the club and note the as 'club member' in a field of the spreadsheet. What I'd like is for this to then fill the list on the next sheet with all the names of people in the club. So if people drop out or get added in, it dynamically changes the sign up sheet, and I can print it out each week for signatures. Can you explain the process a little bit more?

Hi Yogi,

OK, this is roughly the idea.

As people sign up, I number them from 1-20 (the maximum size of the club). I then ask them to confirm their membership after supplying some more information. If they opt out at this point, I renumber them NA#, and change the numbering below. The number, and the confirmed status, then triggers the B column formula to say 'Yes' or 'No' on them being a member.

What I want to do in the second sheet is to have it auto-fill all those still listed as members, keeping in mind this may be less than 20. I then print that off and get them to sign it at the club.