I have 1 question
I used formula in Cell A1 in sheet 1 is =sheet2!B1
But when copy this formula to Cell A15 in sheet1 , it should return to =Sheet2!B2 not =Sheet2!B15
Same for multiples of 15 like cell A30, A45 should return =Sheet2!B3 & =Sheet2!B4 respectively
Is there any way to do that ?
Thanks in advance 😊
By: My friend