Protected Stock sheet in Excel
Posted on 2012-04-02
Will try and keep this short. I work for a multi site company, split into 6 separate divisions, at the end of the month a stock sheet is filled out in excel, this is comprised of the amount of finished/raw/w-i-p stock for each division and is a shared spreadsheet.
All the figures are then transferred into a summary sheet, the problem at the moment is that users are going into there division as and when they want to change there stock figures.
Does anybody have a better idea of doing this? Is there a way of assigning a button which would look the sheet after the user has inputted the figures?
Any help with this would be greatly appreciated.