Hello,

I am trying to navigate through Excel, and one of the issues I'm running into is being able to create a formula template that will save formulas to automatically enter information when importing from SAP.

I have two different worksheets and am linking the imported sheet to a cover sheet I've created in Excel. The easy part was summing the different parts of each category that link perfectly. The problem is that when I sort the imported sheet, it will scramble the order, and my summations in the cover sheet will no longer be the same.

I thought this would be easy until I did that.


How should I go about locking the cells in the imported sheet, so that when I sort from greatest to smallm or smallest to greatest, that the sums in the cover shet DO NOT CHANGE!

I think this is way above my level of expertise on Excel!

Thankyou