hi-i have a worksheet that i need to format so that data can be entered/tallied on a regular basis. Ex: data is entered in 'column D' and later need data is entered in 'column D' but the previous data that was entered needs to be tallied over to 'column C' without having to retype, etc. and this will happen several times thoroughout the worksheets use. I also need to LOCK certain columns/rows while allowing others to be changed.
I will be the person formating and using the worksheet but different people will be the ones entering the data in 'column D' and that is all they will do each time they open the worksheet is update the column with thier new numbers.
I HAVE ATTACHED THE WORKSHEET FOR REFERENCE
Bookmarks