I know that the following function returns the Sheetname for the current Worksheet:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)
But I'd like to return the Sheetname for the Worksheet that is one tab to the right. Is this possible?
I add new Worksheets with each new day with data relating to that particular day. I also have a 'Master' Worksheet and I'd like to be able to refer to the latest Worksheet, i.e. one tab to the right, within a formula without having to manually enter the name of that Worksheet.
Thanks
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)
But I'd like to return the Sheetname for the Worksheet that is one tab to the right. Is this possible?
I add new Worksheets with each new day with data relating to that particular day. I also have a 'Master' Worksheet and I'd like to be able to refer to the latest Worksheet, i.e. one tab to the right, within a formula without having to manually enter the name of that Worksheet.
Thanks