Hi NBVC

I have attached a sample database.

For the yellow columns - the user inputs the requirements into worksheet 'Cost Summary' which is then used in formulas in the worksheet 'Evaluation'.

For the green columns - the user inputs requirements into worksheet 'Evaluation' which is then displayed on the worksheet 'Cost Summary'.

The problem is coming when the user wants to sort on 'Cost Summary' by the columns "weighted score" or "priority score" instead of how it is currently sorted by road ID number. is there a way to lock entire rows to one another on different worksheets?

Thanks for your help.

Attached Files

PATH COSTS - SAMPLE.xlsx (29.8 KB, 13 views)