Forum Discussion
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 ...
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..
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.
Thanks, again.
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..
- congratulations for your good deed... this world needs more people like you
- thanks, lorenzo. it's not just me. there are 1.2 million members of Rotary International in 35,000 clubs all over the world. Rotary has raised $1.5 BILLION for the eradication of polio worldwide. Five cases left last year. Check it out where you live. Business and professional people making the world better. AND, thank you for your help. The macro looks great, but does not do what I need to do. Will keep working on it. Cliff