Big log with multiple international users, must be shared, some only have Excel 2003. Want to prevent overwriting data and getting items into wrong columns, and limit some entries to their own list. Some users have been keeping their own spreadsheet and then copying over into the main log, making a mess.

Simple non-VBA validation doesn't prevent overwriting, nor does it work when entering by forms. What I want is to ensure Data Integrity for metrics to report progress. Am willing to work with VBA but just a beginner with it, although I've created Access DBs some years ago.

Hoping to work with this over the weekend of 3-4dec11. Thank you for any help.

(Accidentally cross posted in old thread as well, not knowing then how to start a new one.)