Hi, I could use some help comparing two Excel spreadsheets. The purpose it to keep up on my college's ever-changing class schedule.
The columns will always be the same. Rows can be added and data in existing rows can be changed.
Example: I would start with File 1 and add some columns at the end with my own notes.
The following week I would receive File 2 containing changes and additions.
I want to get those changes/additions into File 1 so I can maintain my notes but have the most current information.
"Class" is the column that should be used to match on.
Highlighting the changes made would be good too.