Forum Discussion
Extract a subset of data from one sheet and copy to another sheet
You are absolutely right! Now when you say it, the answer seems obvious! You clearly get what I am trying to do. I am running for Council in my town of 40,000. The state gives one access to all the registered voters in town 32,600 ( a bogus number as the state doesn't scrub the data of those who have moved or died). I have to get 400 petitions signed to get on the ballot (1% of registered voters plus a cushion of extras if a nominating petition is invalidated). When someone signs my petition I want to send them a thank you note and highlight them in the database so I know they are a potential supporter of me. Then if I collect enough signatures to get on the ballot, I will continue to contact these folks asking for their vote. Thank you so much for your help.
