Number

[HannahGS1992]

Hey Guys, 

How can I select a cell and just by clicking on it, it will go from 1 > 2 > 3 >4 etc. 

I need to fill in some data and want to fasten my proces by cliking instead of filling it all in? 

Thank you guys for helping in advance. 

[#2]

Hi, @HannahGS1992 

If you know a bit about Macros then you could set the style of the cell you want to trigger the 1+ into as something called "Adder" or similar

Then add this code into the worksheet

Option Explicit

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Target.Cells.Style = "Adder" Then

Target.Value = Target.Value + 1

End If


End Sub