madmardjealas
New Member
- Joined
- Jun 12, 2015
- Messages
- 5
Hello from a first timer on this forum. My boss built a report card which is so stiff and complicated I usually have to enter data from 4 or 5 different spreadsheets onto one. I've been introduced to some neat Excel commands, but have yet to figure this one out.
First, I have an excel sheet1 with this data on it:
<tbody>
</tbody>
Now the students are working on a tablet that generates an excel spreadsheet of marks in this format:
<tbody>
</tbody>
These marks are on sheet 2. I want to get these marks to sheet 1, base on the students name and the course name. Any ideas would be greatly appreciated. Otherwise I have to enter each mark individually, about 8500 data points. yay.
First, I have an excel sheet1 with this data on it:
Course | Mark | Out Of |
A Day in the life of a Medic | 10.0 | |
EMS & City SOP's | 10.0 | |
Patients with a Tracheostomy | 10.0 | |
NRP | 10.0 |
<tbody>
</tbody>
Now the students are working on a tablet that generates an excel spreadsheet of marks in this format:
Name | A Day in the life of a Medic | EMS & City SOP's | Patients with a Tracheostomy | NRP |
Bob Smith | 10 | 7 | 9 | 10 |
<tbody>
</tbody>
These marks are on sheet 2. I want to get these marks to sheet 1, base on the students name and the course name. Any ideas would be greatly appreciated. Otherwise I have to enter each mark individually, about 8500 data points. yay.