Mark Horsfall
Member
Hello
I have posted a similar thread about this but was recommended by a user (Luke M) to change the format of the sheet. So I modified the sheet....hence the re post
I was wanting help putting information from one sheet to the next.
I want to track the progress of children in my class.
I wanting the children's attainment in Autumn term to transfer into Spring term.
So for example - Umar achieved NYR in Autumn Term and Emerging in Spring term.
So his name needs to go into any of the cells K40:N45
I was wanting a formula to do this automatically for all of the children and for all the cells.
In sheet 1 I used an index formula and was wondering if something similar could be used.
So the formula needs to look to see what the child achieved in Autumn term and Spring term and put their name in the correct cells for all the children in sheet 1.
I have attached the sheet.
Hope you can help
Mark
I have posted a similar thread about this but was recommended by a user (Luke M) to change the format of the sheet. So I modified the sheet....hence the re post
I was wanting help putting information from one sheet to the next.
I want to track the progress of children in my class.
I wanting the children's attainment in Autumn term to transfer into Spring term.
So for example - Umar achieved NYR in Autumn Term and Emerging in Spring term.
So his name needs to go into any of the cells K40:N45
I was wanting a formula to do this automatically for all of the children and for all the cells.
In sheet 1 I used an index formula and was wondering if something similar could be used.
So the formula needs to look to see what the child achieved in Autumn term and Spring term and put their name in the correct cells for all the children in sheet 1.
I have attached the sheet.
Hope you can help
Mark