Mark Horsfall
Member
Hello
I was wanting to put the names from the first sheet into the second sheet to show progress of children.
So all those children who in Autumn term who were NYR go in row 10 but in the assessment stage they achieved in spring term.
So for example Umar the first child I want to go in E10 on Sheet 1
I don't know what formula I could use to automatically do this and how I could do it for all the children in the reading stage progress (the first sheet).
Can you help. I prefer to use formulas than macros as I have a better understanding of those. On the first sheet I used an index formula I am not sure if I would need to use something similar for what I desire here.
I have attached the file
Hope this is possible and I hope you can help
Mark
I was wanting to put the names from the first sheet into the second sheet to show progress of children.
So all those children who in Autumn term who were NYR go in row 10 but in the assessment stage they achieved in spring term.
So for example Umar the first child I want to go in E10 on Sheet 1
I don't know what formula I could use to automatically do this and how I could do it for all the children in the reading stage progress (the first sheet).
Can you help. I prefer to use formulas than macros as I have a better understanding of those. On the first sheet I used an index formula I am not sure if I would need to use something similar for what I desire here.
I have attached the file
Hope this is possible and I hope you can help
Mark