I have an advanced excel question, is there anyone that really knows excel?  

I am making a bill PAYMENT workbook.  I have 12 worksheets, one for each month of the year.  I also have a bill information SHEET.  I'm wanting to show the current balance of each bill on the information sheet, but I can't figure out how to make it show the most recent entry.  I.E. if it's January I WANT January's balance to show, if it's October I want October's balance to show.  Any ideas on how to accomplish this?Well, I've been an Excel user for many years, but your question is complicated and I don't think I'm going to tackle it.  Perhaps someone ELSE will, but I suggest you also post it at http://www.excelforum.com/.  There must be some function to return the date, or the current month, or something. Try using If statements for the different range of values for each month. Quote

Well, I've been an Excel user for many years, but your question is complicated and I don't think I'm going to tackle it.  Perhaps someone else will, but I suggest you also post it at http://www.excelforum.com/.