=+'Names for Roster'!$C$3
I am printing a membership directory for my club. Now that it is all laid out for 200 members my board wants to add a birthday that is saved on the 'Names for Roster' worksheet in column H in a format like 8/16 for August 16. I thought I would use: =CONCATENATE("Birthday: "& TEXT('Names for Roster'!H3,"mm/dd")).
What is the easiest way to enter this changing the row reference in the formula for all 200 members? I thought I could get the row number from the exiting formula shown at the beginning of my question. This formula is up one row and to the left one column from where the birthday cell will be.