Hello all,
Can the below formula be made to show the previous sheets name in a workbook.
For example in my workbook the sheet tabs are 01.07.09 - 02.07.09. Is there a way if I right click on tab 02.07.09 and copy it into the same workbook giving me tab 02.07.09 (2) that a cell in the copied workbook will show the previous tab name.
I need to use this as a reference for a formula I'm using in creating a running balance.=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
My solution would be to define a very simple User Defined Function like:
=GivePrevSheetName()
Now it can be used e.g. =INDIRECT(GivePrevSheetName()&"!$A$2")
The code for this function is:
Please Login or Register to view this content.
Last edited by rwgrietveld; 06-24-2009 at 05:20 AM.
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks