Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-17-2012, 10:31 AM
cklassen cklassen is offline Can't get formula to recognize correct data Windows 7 32bit Can't get formula to recognize correct data Office 2010 32bit
Novice
Can't get formula to recognize correct data
 
Join Date: May 2012
Posts: 1
cklassen is on a distinguished road
Default 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.
Attached Files
File Type: xlsx Cheques.xlsx (32.8 KB, 12 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't get formula to recognize correct data Sum Formula in the range with Numeric and NonNumeric data cells Spanec Excel 2 01-12-2012 09:15 AM
Can't get formula to recognize correct data Changed data base name. Outlook doesn't recognize. Skip Outlook 1 10-20-2011 10:55 AM
Can't get formula to recognize correct data 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
Can't get formula to recognize correct data Cross-reference together with Mathtype formula is not working correct Santa_Clause Word 2 02-02-2010 04:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:21 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft