Good morning/evening,
I am trying to complete some assessment work and VBA is not my forte at all. There are a couple of things that I need to do for an assessment. I have a Date that I need to subtract from a cell on a sheet called summary (sheet1) and a DOB cell on a sheet called combined (sheet2) I need to store the answer in a column called age. I then need to put them into categories. I am completely stumped with what to do.
Can anyone help?
The following tasks (not listed in any particular order) are to be accomplished with mcrValidate:
• In row 1 of sheet Combined write the following column headings: Last name, First name, Gender, DOB, Address, Suburb, State, Postcode, Role, Category.
• There was a variety of fonts in the eight individual states sheets which will be carried into sheet Combined during the import. 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 age categories from Junior to Great Grand
Master are shown in the table below. For each row generate the age category. Hint: Firstly, for each row subtract DOB from your Nationals date (see Summary sheet) 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 – for example if a person is 50 years old write Grand Master in the Category column.
Please help I have so many issues with thinking out this code.
Tyrulas
Bookmarks