Hoping to get some suggestions on something I'm stuck with.
I have a master sheet that I replace all the contents once a week (via a mass copy and paste). I have a group that needs to add data to one of the columns, however I'm trying to find a way of avoiding them from having any type of write access to the master sheet. In an ideal world, I was hoping to be able to create a report for them with a column they column they can update without feeding back to the master, since each week I replace everything with new data that comes from an external report. I would then tie the two sheets externally. I know it sounds sort of messy, but hope it makes sense somehow.