I am the secretary for my volunteer fire department. To maintain active status, all members have to log 14 hours a month. We have a sheet that a prior secretary made that the members write their hours on, and turn in. Currently each month I have to print 42 copies of the sheet, and write everyone's names, badge numbers, and the month on them.

What I am looking to do is be able to list all the member's names and badge numbers, and the month, and have it output a sheet with the names, badge number, and month already filled in, that way I don't have to write 42 members names down.

I don't have a copy of our actual file with me, but I made one that looks very similar up, and have attached it.

Again, I just want to make it so the Name: Unit #: and Month: fields are already filled in with information from a list for printing.

Is this possible?

Thanks

Attached Files

Book1.xlsx (11.2 KB, 10 views)