Hi all,
I have a sheet where a user presses a number of buttons and have a macro in place that counts the amount of times the button was pushed. Now I would like to add a column that records the time at which each click occured.
Eg Using column J to display the data;
Starting from cell J6 which will display the first time at which the button was pushed
Every time the button is pressed i would like the time it was clicked displayed on row below the cell that displays the previous time it was pushed
Ie 1st push J6 = 9:00am
2nd push J7 = 10:13am
3rd push J8 = 3:40pm
and so on
I beleive this is possible with a looping of an offset function, but wasnt exactly sure of how to fine tune it.
If anyone could assist that would be great
Cheers
Bookmarks