N
NHALDI
Hi guys.
I have a spreadsheet that needs to be sent to regional offices so the
can populate some figures. There is information on the spreadsheet tha
I don't want them to change so I have locked 'my' cells and protecte
the worksheet.
Once they have populated their figures, I want them to be able t
somehow lock 'their' cells before they forward the spreadsheet to thei
stores, leaving another range of cells unlocked for the stores t
populate.
So in effect there are three stages of data input and stages one and tw
need to be locked independently.
Is there any way to do this on a single spreadsheet/workbook so tha
various users can enter info and then lock it before sending forward?
Many thanks
Nei
I have a spreadsheet that needs to be sent to regional offices so the
can populate some figures. There is information on the spreadsheet tha
I don't want them to change so I have locked 'my' cells and protecte
the worksheet.
Once they have populated their figures, I want them to be able t
somehow lock 'their' cells before they forward the spreadsheet to thei
stores, leaving another range of cells unlocked for the stores t
populate.
So in effect there are three stages of data input and stages one and tw
need to be locked independently.
Is there any way to do this on a single spreadsheet/workbook so tha
various users can enter info and then lock it before sending forward?
Many thanks
Nei