Can't get formula to recognize correct data
What I need the spreadsheet formulas to do is for cell A20 = cell AF5, cell B20 = cell AG5, cell C20 = cell AH5, etc. and then cell A21 = cell AF8, cell B21 = cell AG8, cell C21 = cell AH8, etc., until the data reaches AF38 (which says Invoice Number). At that point the rest of the cells on the cheque stub should return no data. This way I can create custom cheque stubs for each cheque no matter how many invoices are paid on each cheque.
The formula I currently have in A20 is like B6, B9, B10, B11, etc. but it's not doing what I want it to.
Please help, I've been working on trying to get this set up for at least 20 hrs of my time.
|