Forum Discussion

cliff brock's avatar
cliff brock
Copper Contributor
Sep 12, 2018

Pulling registrants for current year from master list

I

I have a question to post.
 
I have 900 names, addresses, etc. for a charity event. Each year we register approximately 300 of these names. For a different charity event, I use vlookup to build the "current" participant list. There, I have a "unique" number (member number), and we scan from name badges. With the 900 names, I use a dropdown list to put in year in the "master" file. But, in the "current" year, I do not have a unique number to use for vlookup to build the list of current registrants from the master. I have been pulling all 900 into current year and filtering by year, but that is not efficient at all. How might I select current registrants from the "registration master" and put them into this year's list of registrants? I have account numbers for them, but they are not used. Ideas?
excel
Formulas and Functions
  • Lorenzo Kim's avatar
    Lorenzo Kim
    Bronze Contributor
    Sep 12, 2018

    I don't know if I get you right but I prepared a sample for you to test.

    I hope that it may help you to come up with something.

    thanks..

    • cliff brock's avatar
      cliff brock
      Copper Contributor
      Sep 12, 2018

      thanks for the help. Whaat you attached appears to be a PDF so I can't see how it runs. I have attached dummy file of what I'm working on. The names do not repeat, but I think you can se what I'm trying to do. I pull this year's registrants from the master. The master is built by online registration, a paper form or onsite. I want to use master as my database and then pull current year registrants from it to a tab for current year participants.

       

      BTW, we raise about $40,000 in Rotary scholarships through this event each year, so a great many kids will really appreciate your help.

       

      cliff

    • cliff brock's avatar
      cliff brock
      Copper Contributor
      Sep 12, 2018
      dummy that I am, I just figured out how to open your sample in excel. I will see if I can use your code in my file. (I am not a VBA guy, though!)

      Thanks, again.
      • Lorenzo Kim's avatar
        Lorenzo Kim
        Bronze Contributor
        Sep 12, 2018

        Mr. Brock

        Basically, I think the sample I sent you is it.

        if sheet "REG" is used (finished) - copy it to a new sheet and rename it  (say, REG-2018) THEN clear "REG" so that you can re-use it for new entry.

        you can re-format all columns to suit your requirements and maybe add some pertinent data.

        Hope it will work fine for you.

         

        thanks..

Resources