Copying Data from cells above

[Shazz]

I want to fill cells in a column with data (PRI134/18) Can anyone advise how I can do this as when dragging the cells down it changes the last two digits to 19, I want the number sequence before the / to change to i.e PRI135/18, PRI136/18 and so on.

Your help is appreciated.

Shazz
x

 

[My Aswer Is This]

You can use this vba script:

It will enter the values into column (1)

You did not say when you want to stop.

So a Inputbox will ask you how many times.

Sub Fill_Down_Now()
'Modified  10/17/2018  5:16:26 PM  EDT
Application.ScreenUpdating = False
Dim i As Long
Dim Lastrow As Long
Dim ss As Long
ss = 134
Dim ans As Long
ans = InputBox("How many times")
    For i = 1 To ans
        Cells(i, 1).Value = "PRI" & ss + i & "/18"
    Next
Application.ScreenUpdating = True
End Sub

 

[MARK858]

Just a possible formula solution. A2 dragged down.

Excel Workbook
	A
2	PRI134/18
3	PRI135/18
4	PRI136/18
5	PRI137/18
6	PRI138/18
7	PRI139/18
8	PRI140/18
Sheet1