numerical update

tuggers1975

New Member
Joined
Mar 25, 2020
Messages
7
Office Version
  1. 2013
  2. 2010
Platform
  1. 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.
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Forum statistics

Threads
1,213,532
Messages
6,114,177
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top