Data

[Eddyoftheyear]

Hi All,

I have a data for 50 departments. Each department has 100 or more staff members. I have to send each deparmtne the data and they may make changes to it. I want to be able when I get the data back to filter out what was not changed and keep the one with the changes,

What would be the best way to do this. I can use excel or access.

 

[randy700]

If you put the data in an Access database, you could create front ends for each department and let them do the updates themselves. Reduces the chances for errors from re-entering the data.

Randy