Hi everyone,

I have an issue here. I have a master file with data that I export once a week to send out to clients.

First problem is that everyone that is sending out the data can edit on the sheets, but does not change it with the correct data. How can I prevent editing on these sheets and templates from other users?

Second on is that; I have about 19 clients to send the stock on hand to but not all clients gets the same products. I do have a a template out with all the clients and with each sheet having their products on the sheets. How can I make it easier to edit in the future and also not to have other users making the mistake to send out the wrong stock on hand?

I do hope that this is posted in the right place