This confuses me: 'I would like to display the 3 combination in one'.
I interpreted this as you want the solution to work for all 3 scenarios.
The code below will fire once you make a change in cell G3:
- Column A, starting at row 6 will be cleared.
- Column A, starting at row 6 will be numbered to the amount entered in cell G3.
- Spacing between the numbers will be determined by how many cells in range C3:E3 contain data.
Here is the code:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim mStep, NoR, x, y As Integer
If Intersect(Target, Range("G3")) Is Nothing Then Exit Sub
mStep = WorksheetFunction.CountA(Range("C3:E3"))
NoR = Target.Value
x = 6
Range("A6:A" & Rows.Count).ClearContents
y = y + 1
Cells(x, "A").Value = y
x = x + mStep
NoR = NoR - 1
Loop Until NoR = 0
Using the code is done by right-clicking your sheets tab and select "View code". Paste the code in the big white field that pops up.