I am trying to collate student marks. Because of the different systems, all the lists are different, so I can’t just copy and paste between sheets. However, there is one sheet (“MARKS”) which contains the correct current list. What I need to do is to copy the marks from another sheet to this one.
Something like this:
- For each student, the first cell in that row will be an ID number; search in the next sheet (“Other”) for that ID number.
- Copy the value from the last cell in that row in “Other” to the relevent cell in the current row of “MARKS”.
For example, suppose I’m in row 49, and cell A49 of sheet “MARKS” contains “12345678”. Seaching in sheet “Other” finds 12345678 in row 53. So I need to copy K53 to E49.
Is there an easy way to do this?