Locking data in a summary sheet

Hi

I have a work book that contains several sheets.
At the beginning of the workbook I have a summary sheet that
Contains the totals from each sheet in the workbook.

I have created a copy of this summary sheet in the workbook .
I’m looking for away to lock the info on this sheet, so
The totals will not change as the sheets in the work book
Get updated. So I can use it to show the start point as
The project goes on.

Any help will be appricated

Thanks

From your description I think you will need VBA to "fix" your data.

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.