Pass row number as variable in excel sheet
Try this easiest solution :
Use this below link to more information,
Use this OFFSET method :
The column value is save in B1, and follow the below code,
C1 = OFFSET(A1, 0, B1 - 1)
Running this methods :
a) Getting a base cell, that is A1.
b) preservation it as A and adding 0 to the row.
c) In the column to adding ,A5 – 1.
In case want to modify the row value by using another value instead of 0.