I've created the attached spreadsheet in order to make a custom cheque stub with the data provided from my accounting software. I have everything working exactly as I want except for one thing.
This formula =IF('CHK row'!J1="""","",INDEX($A$2:$AB$60,1,1)) works great. However, I want the "$A$2:$AB$60" to change for the next cheque so that it is $A$37:$AB$95 and the next cheque to be $A$75:$AB$133 (see CHK row tab column K data). The problem is that when I try to change =IF('CHK row'!J1="""","",INDEX($A$2:$AB$60,1,1)) to =IF('CHK row'!J1="""","",INDEX(K1,1,1)), the formula doesn't work because K1 ($A$2:$AB$60) is a string of text I think. I want to be able to have the formula =IF('CHK row'!J1="""","",INDEX($A$2:$AB$60,1,1)) automatically change for each check's data.
Please help by letting me know another way to insert a changing cell range inside a formula that will actually work for me.
Bookmarks