Selected Answer
Please try this formula.
=$B$30+(INT((ROW()-30)/10)*16)
The formula calculates each cell's value based on the original you entered in B30. Please change the column if B isn't the column you work in.
Enter the starting value in 30 of the column indicated in the formula. Paste the formula to the cell immediately below that and copy from there to the bottom of your sheet. All values will change if you modify B30.
Since you have many rows to paste the formula to note this quick way of selecting a large range. On the Ribbon's Home tab click on Find & Select. Select GoTo and enter the range you wish to select in the Reference field. Click OK. You can use this feature to copy/paste. For example, select B31 and click Copy (or press Ctl+C). GoTo B32:B10500, press OK in the dialog box and then press Enter to confirm the selection and to complete the pasting process.