Forum Discussion
Past cells into visible cells
I have one excel sheet with student ID numbers. This is only active students. I have another excel sheet with all students past and present. I would like to get the student ID numbers of the active students into the workbook with all students without having to copy and paste each one. I have a filter on the workbook with all students set to just active students so that the ids would like up with the correct student. But when i go to paste it pastes into hidden cells or wont let me paste at all.
i want to copy the ones on the left and paste them into the right (these 4 are just an example there's over 600 I have to do and would much rather not go one by one)
1 Reply
- It sounds like you need to use a lookup function. Try something like:
=INDEX(master student list ID column, MATCH(student identifier, master student list identifier column, 0))
Of course you'll need to find a name, email address, or other way of cross-identifying the students between the two lists.
