Trevor3007
Well-known Member
- Joined
- Jan 26, 2017
- Messages
- 667
- Office Version
- 365
- Platform
- Windows
Hi,
I have to do huge desk survey . These are the headings ( d5 - f100)
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.
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.