Dear anyone who can help me,
I have a workbook with multiple sheets. On 'Sheet 1' I have a formula in a cell that finds the last populated cell in the row and displays that information:
e.g. E A B C D E
(The bold letter above represents the cell with the formula. The letters after represent the following cells).
Here is the formula: =INDEX(Q8:AE8, MATCH(REPT("z",255),Q8:AE8))
It works perfectly.
My problem is that I want the cell to display the last populated cell OVER MULTIPLE SHEETS.
I have tried =INDEX(('Sheet 1'!Q9:AF9, 'Sheet 1a'!Q9:AF9), MATCH(REPT("z",255),('Sheet 1'!Q9:AF9, 'Sheet 1a'!Q9:AF9)))
And also =INDEX('Sheet 1:Sheet 1a'!Q9:AF9, MATCH(REPT("z",255),'Sheet 1:Sheet 1a'!Q9:AF9))
Am I attempting the impossible here? Any suggestions as to what may work in this situation?
Any help will be very much appreciated.
Bookmarks