Weekly updating spreadsheets

[Stewie1288]

Hi,

I'm new to the forum, and am not an excel guru by any means, so forgive me if I'm not initially clear enough or use incorrect terminology, but I'm going to try and explain my plight.

I work at a university in the graduate office, every week we receive a spreadsheet with a pivot table that allows us to sort through all students by location (we have multiple centers), program, etc. etc.

My task is to take that information and create spreadsheets that our program reps can use to easily check the status of the students in the database (separated by admitted/applied/inquired). They also want to be able to add comments to each person.

The problem I'm running into is that if I reformat the weekly spreadsheet to be able to do that, I see no possible way to be able to update the list when I receive the next one and still keep the same formatting and added comments. (The lists and tables contain thousands of students so manually updating the lists is out of the question)

Is this even a possible task? Would it be possible if i received a list of only the recently added students?

Thank you for your time.

If you need any clarifications do not hesitate to ask.