calc & output to another worksheet

[Trevor3007]

Hi,

I have to do huge desk survey . These are the headings ( d5 - f100)

Dock

USB3

K/B

Mouse

Monitor

HDMI/DVI

DVI/DVI

In the retrospective rows below, if a 'keyboard' is missing, I enter 1 . I set up a a =sum formula to capture the totals & these totals are contained in a another worksheet(sheet name = Totals) contained in the applicable workbook.

The problem is that the users delete cells/rows which then messes up the calc. Is it possible to use VB rather than "=sum" and return the results in the 'totals' worksheet.

Many thanks for your assitance.

 

[Crystalyzer]

Why not protect the workbook and prevent users from deleting rows and columns?

 

[Trevor3007]

Why not protect the workbook and prevent users from deleting rows and columns?

Thank you. Much appreciate your help. Cannot use as it prevents the VB from working.