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?
I don't know anything about 'advanced excel', I just use the standard Excel as issued in MS Office.Originally Posted by trucknroll
If you name your sheets as the Month you can access the sheet via
=INDIRECT(TEXT(A1,"mmm")&"!a1")
If you have the Sheet names listed somewhere you can access that list by
=offset(A1,(month(now())-1,0)
thus
=(sheetname as listed in column A)!A1
becomes
=INDIRECT(OFFSET(A1,(MONTH(NOW())-1),0)&"!A1")
but this is just the usual simple stuff.
Does this point you in the right direction?
---
Last edited by Bryan Hessey; 09-28-2006 at 10:37 PM.
Okay, more advanced for me. It seems pretty confusing. I don't have a list of the names of the worksheets tabs. Also my balance isn't in the same cell on each month's sheet. So that confuses me more.
ok - so - how are you going to refer to each sheet? - what are their twelve names, and how are you going to identify the figure to be displayed, what is the criteria that identifies which cell?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks