Hello there,
I need to get formula to get data from the last Sheet of my workbook. I know, I have 36 Sheets, there are different names for them, one part starting wit KW then space and number. Another one starts with WER-Zus. space and then numbers as month and year, so for example WER-Zus 10.2015. What I need is formula, that gets the data from specific cell from the last sheet an compare it with data in actual sheet.
I tried relative reference =SHEETS(27)&P32, but it does not work. I don´t want to solve it with vba.
Thanx in advance.
I need to get formula to get data from the last Sheet of my workbook. I know, I have 36 Sheets, there are different names for them, one part starting wit KW then space and number. Another one starts with WER-Zus. space and then numbers as month and year, so for example WER-Zus 10.2015. What I need is formula, that gets the data from specific cell from the last sheet an compare it with data in actual sheet.
I tried relative reference =SHEETS(27)&P32, but it does not work. I don´t want to solve it with vba.
Thanx in advance.
