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, 8 views)

Something like the attached?

Attached Files

Volunteer Fire Dept East Wood.xlsm (19.7 KB, 18 views)

You could also try using Word's Mail merge functionality if you have it

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Awesome. That is exactly what I needed.

Thanks a ton!

I took the liberty of playing around with your workbook a little more.
Have a look at this and see if it helps you at all.

Regards

Attached Files

Volunteer Fire Dept East Wood New.xlsm (52.8 KB, 11 views)