tuggers1975
New Member
- Joined
- Mar 25, 2020
- Messages
- 7
- Office Version
- 2013
- 2010
- Platform
- Windows
Hi guys,
Please could you help me with the following??
I have previously used vba a lot but haven't used it in anger for quite a few years now and want to get back into it.
I have a sheet that is used for recording call logs.
Essentially we record the number of telephone calls received every hour from various different sources, to provide a summary at the end of each day.
I want to be able to click on a cell nominated as a particular hour of the day and a particular source, with that click generating an entry in the summary sheet, and each subsequent click on that cell to increase the entry by one.
This sheet would have to be duplicated across several members of staff in the same workbook to generate a department summary sheet
would greatly appreciate your guidance for this.
Please could you help me with the following??
I have previously used vba a lot but haven't used it in anger for quite a few years now and want to get back into it.
I have a sheet that is used for recording call logs.
Essentially we record the number of telephone calls received every hour from various different sources, to provide a summary at the end of each day.
I want to be able to click on a cell nominated as a particular hour of the day and a particular source, with that click generating an entry in the summary sheet, and each subsequent click on that cell to increase the entry by one.
This sheet would have to be duplicated across several members of staff in the same workbook to generate a department summary sheet
would greatly appreciate your guidance for this.