mummbles74
Board Regular
- Joined
- Nov 14, 2009
- Messages
- 125
- Office Version
- 365
- Platform
- Windows
Ok, I have been searching and searching for examples but struggling to find a suitable starting point.
May aim is as follows; I have a list of candidates in that table there is there Name (column A starting in row 3), Group number (Column B), Discipline (Column C).
The 2 Disciplines at the moment are Performer and Designer
For each discipline I have a sheet with an assessment template these sheets are names the same as the discipline
What I want to be able to do is fill out the table with the candidate details and then hit a generate button and it create an assessment template for group. The difficulty is that each group could have different numbers of candidate and each group could have a different number of Performers and Designers.
Eventually I would like for each candidates section to obviously reflect there role and have there name in a cell.
For clarity each of the templates for the different roles are laid out the same and are currently the same size. The name on every template would need to be entered in Cell A6 on the sheets. the layout for each assessment for ranges from A1:H16.
I appreciate this is quite vague but I am struggling to ascertain which way to go to be the most effective from the start.
I would be happy if a new sheet would be created for each group with the sections pasted in there.
Any help or points to get me started would be appreciated.
May aim is as follows; I have a list of candidates in that table there is there Name (column A starting in row 3), Group number (Column B), Discipline (Column C).
The 2 Disciplines at the moment are Performer and Designer
For each discipline I have a sheet with an assessment template these sheets are names the same as the discipline
What I want to be able to do is fill out the table with the candidate details and then hit a generate button and it create an assessment template for group. The difficulty is that each group could have different numbers of candidate and each group could have a different number of Performers and Designers.
Eventually I would like for each candidates section to obviously reflect there role and have there name in a cell.
For clarity each of the templates for the different roles are laid out the same and are currently the same size. The name on every template would need to be entered in Cell A6 on the sheets. the layout for each assessment for ranges from A1:H16.
I appreciate this is quite vague but I am struggling to ascertain which way to go to be the most effective from the start.
I would be happy if a new sheet would be created for each group with the sections pasted in there.
Any help or points to get me started would be appreciated.