Can't get formula to recognize correct data

cklassen · #1 05-17-2012, 10:31 AM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sum Formula in the range with Numeric and NonNumeric data cells	Spanec	Excel	2	01-12-2012 09:15 AM
Changed data base name. Outlook doesn't recognize.	Skip	Outlook	1	10-20-2011 10:55 AM
PowerPoint won't recognize embed codes from YouTube or Vimeo	JulianC	PowerPoint	1	10-04-2011 03:03 PM
Word crashed and now doesn't recognize file as a Word doc?	sara	Word	0	09-15-2010 02:12 PM
Cross-reference together with Mathtype formula is not working correct	Santa_Clause	Word	2	02-02-2010 04:37 AM