I have a huge array of data (children's grade results) in an existing spreadsheet. (The sample provided is not the finished product - it only consists of the first three children in Reading). The children's grades are presented by colouring in cells in excel (red, green or yellow depending on whether they have met the target). Their grade is calculated via a look up table depending on how many of the cells are coloured green. If a child has not met 1c, they are classified as being ELG and need a separate individual record for those assessment criteria (as can hopefully be seen by the two separate word documents).
I need some form of VBA programming to transfer these colored cells into the Word document provided below. Ideally, this would be in Word, but it could also be transferred into Excel if necessary. Basically, I want to be able to press a button, and Excel creates reports automatically for me for 30 children in three different subjects. (So 90 sheets).
The sample files I have provided are just for one subject (reading) but I would need the same programming for writing and maths respectively.
I hope I have explained this sufficiently, but it is rather complicated, so I invite your questions if this needs further clarification. Many thanks and I look forward to hearing from you.