Voting Forms

[Matt5353]

I've created a voting form with an active cell that looks up a database of up to 7000 names. E.g. I enter the number 1 and in the active cell on the voting form, it looks up the database and then it adds the member's name to the form. The form is then printed, this will stop us from printing up unnecessary forms. Printing as you go is far more proficient than printing of 1000's of forms just in case.
At the moment we print up to 2000 forms with 4 forms for each member to vote for their preferences of either President, Senior, Junior or Committee. Once the form is created I wish to have their club Number and Name added to another sheet which will be called (Who Actually Voted) to show how many people actually voted in the election.
I can do that but if I go back to the voting form and put 2 in the active cell the name changes in (who actually voted). So I wish to stop that from happening and just get them to show up as a list.

 

[Drrellik]

It sounds like you have a handle on using Vlookup (I'm assuming you are using Vlookup) to populate your voting form with the member's name, then you print the form and change the number for the next member.

perhaps you can simply create another sheet or column outside your print area on the page you are using and when you enter 1 in your active cell, simply add it to your new column active cell
and continue to add the members as you print your forms.

Book1
	A	B	C	D	E	F	G	H	I	J
1	1	Voting	Form				New Column	1	Vlookup	for club #
2		Name	Based on	A1				7	Vlookup	for club #
3								15	Vlookup	for club #
4								21	Vlookup	for club #
5								33	Vlookup	for club #
6
7
8
9
10
11
Sheet1

 

[Matt5353]

I have very basic knowledge of vlookup. Not understanding what you mean and how to do that with vlookup, I thought a macro might be needed. I used on the sheet Who Voted =B5 for the number and =D5 that is as far as I got. This is my =VLOOKUP(B5,DataBase!A1:D20,4,FALSE) to get the name on the form. I still do not understand how to put together a vlookup code to start listing the names.

	Election of Officers	2023/24
	Club Number	Name
	1	Kenneth Wood
	Voting Form for "President"
	Please Tick "One Box Only"
1	Applicant:
2	Applicant:
3	Applicant:
4	Applicant:

 

[Drrellik]

OK,

It looks like you are using one Sheet to print voting forms. call it sheet 2. and on sheet 3 you named it DataBase and that is where you store your club member's names and member IDs or numbers.

What I was suggesting is that you create a 3rd sheet or rename it something like Voting List

then use the same Vlookup you already created and simply keep track manually as you print your form.

So when Member 3 asks for a voting form and you put a 3 in B5 in order to pull his/her name into cell D5 when you hit print simply tab over to sheet 1 or the Voting List sheet and type a 3 in column A to populate column B with the member's name

With each subsequent voting member form being printed you will just add their number to Voting List Sheet

Book1
	A	B	C	D
1		Election of Officers		2023/24
2
3		Club Number		Name
4
5		1		Kenneth Wood
6
7		Voting Form for "President"
8
9		Please Tick "One Box Only"
10
11	1	Applicant:
12
13	2	Applicant:
14
15	3	Applicant:
16
17	4	Applicant:
Voting Form

Cell Formulas
Range	Formula
D5	D5	=VLOOKUP(B5,DataBase!A1:D20,4,FALSE)

Your information posted.

Guessing at sheet BataBase

Book1
	A	B	C	D	E
1	1			Kenneth Wood
2	2			Jim Crow
3	3			Bob Dylan
4	4			Dylan bob
5	5			John Smith
6	6			this list is 7000 ppl long Im guessing
7	7
8	8
9	9
10	10
DataBase

My Idea about adding a tracking sheet done manually with each form printed.

Book1
	A	B
1	1	Kenneth Wood
2	5	John Smith
3	3	Bob Dylan
Voting Tracker

Cell Formulas
Range	Formula
B1:B3	B1	=IFNA(VLOOKUP(A1,DataBase!$A$1:$D$7000,4,),"")

 

[Matt5353]

Thanks, I know I could do that but didn't want to add another layer to it. The Data Base and the Who Voted will be sheets hidden from those people who will be the scrutineers that actually will be processing the forms for voting. I want it to automatically do this so the process is only one step rather than several steps.