Question:
How would you manage multiple people adding same kind of data into a
spreadsheet?
Situation:
This company uses Excel spreadsheet as final form for their sales
peoples. So, each person pulls his/her own data from CRM subsystem, and
adds to this spreadsheet. Well, a moron overwrote other people's
entries, and lost entire weekend's work.
So they ask me, and I said, "I don't know, but I'll ask around".
In my previous companies, such spreadsheet would be on a server. And,
whenever someone opens to edit, it would lock the file. But, this only
addresses "access". Not the "content".
Possible Solution:
I'm thinking "template". Each person would be populating same kind of
data into spreadsheet. So, maybe a script merges data from his/her
template? Maybe, a "web form"? I don't know.
