Ok - this hopefully is simple to explain!
I have a table of 12 rows, with many columns. The table measures students progress through educational courses. - each course split into Modules - modules split into Training Objectives (TO) - TOs split into enabling Objectives (EO) - EOs split into Key Learning Points.
The table will auto populate the EO column against the student with an "N" if any of the KLPs are annotated with an N. EO columns are columns I, N, R and V. Students are on rows 10 to 21.
If the SS populates an "N" in any of the columns I, N, R or V, I want to generate a row in another table below called student issues, and auto populate that new row with the student surname.
[/URL]******** async src="//embedr.flickr.com/assets/client-code.js" charset="utf-8">*********>[/IMG]
Many thanks in advance
Matt
I have a table of 12 rows, with many columns. The table measures students progress through educational courses. - each course split into Modules - modules split into Training Objectives (TO) - TOs split into enabling Objectives (EO) - EOs split into Key Learning Points.
The table will auto populate the EO column against the student with an "N" if any of the KLPs are annotated with an N. EO columns are columns I, N, R and V. Students are on rows 10 to 21.
If the SS populates an "N" in any of the columns I, N, R or V, I want to generate a row in another table below called student issues, and auto populate that new row with the student surname.
Many thanks in advance
Matt
