How to increase numbers for value in Excel

[Jyobtech]

Thanks for response Ankesh,

I am not writing the values in my excel sheet.(I should update the values in excel before the every script execution,otherwise the script will fail.Is there any method insipte of manual updating the values in excel)

I want to do the logic in EXCEL only .
Example in excel column =RANDBETWEEN(10,30) gives only vales between 10 to 30 . I want the same values not in randam order ,it should be countinuesly(Is there any function in excel)