I've created a worksheet with one column of data (hospital room numbers) that
always remain constant. I have 5 columns where data (numbers) will be
entered daily. I have a calculation column where the numbers in the previous
5 columns are totaled (hidden column). I then have a last column that
returns a specific word based on the value in the previous calculation
column.

I need the first column with room numbers, the hidden column with the
calculation, and the last column with the word value to be locked so they
cannot be manipulated. I can do all those things very easily.

The problem is that a user will have to enter data in the middle 5 columns,
and then sort the spreadsheet, and Excel will not allow a sort using the
locked fields.

Any suggestions?