Morning. While mail merge would probably be the best solution and I trust your knowledge. I have been told by the admin manager that a macro is required. I can't unfortunately make any changes to the outlined request as they come from a subsidiary company.

So in regards to the mcrValidate. I was given the following information.

In row 1 of sheet Combined the following column headings: Last name, First name, Gender, DOB, Address, Suburb, State, Postcode, Role, Category.
Standardise all fonts to plain Arial 12 pt.

The column Category in sheet Combined was not in the original states data. Its purpose is to record the age category for each member.

The various categories from Junior to Great Grand Master
Junior - Under 18
Senior - 18+
Master - 40+
Grand Master - 50+
Great Grand Master - 60+

For each member data, generate the age category for column Category. for each row subtract DOB from your Nationals date to find the member's expected age on the day of competition, then compare with the category table below. Write out the category data for the member in full.

I hope this helps. You have already helped immensely and I do appreciate it.