I believe you can put it in google docs, and everybody can merge in their data, and IIRC immediately see others changes. There may be security controls to limit who can enter (by row or cell?) I am in a group where such a spreadsheet was created, we were each exhorted to adopt and update one row in it. I did not rise to the request. Carey
On 04/05/2026 2:17 PM CDT William Park via Talk <talk@lists.gtalug.org> wrote:
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. ------------------------------------ Description: GTALUG Talk Unsubscribe via Talk-unsubscribe@lists.gtalug.org Start a new thread: talk@lists.gtalug.org This message archived at https://lists.gtalug.org/archives/list/talk@lists.gtalug.org/message/PDDJ47L...