Hello,
I'm hoping someone can assist. I have run into another issue. I have a workbook that has several sheets. The sheets are created based on a named range. What I am trying to do is with the main worksheet ("Project Tracker"), I am trying to enter a formula in the Due by date. If the name matches one of the excel tabs (worksheets), it will look in the last row of the matching tab and place the date.
Example:
Main Sheet Project Tracker
Col A Col B Col C Col D Col E
John 214212 Dallas TX
Martha 244382 Memphis TX
Now the formula I've used work's great but as you will see , it is row specific:
I have tried using various "last row" codes but keep getting an invalid cell reference error. For example, I tried using,
I'm stumped
so any assistance or guidance will be greatly appreciated.
I'm hoping someone can assist. I have run into another issue. I have a workbook that has several sheets. The sheets are created based on a named range. What I am trying to do is with the main worksheet ("Project Tracker"), I am trying to enter a formula in the Due by date. If the name matches one of the excel tabs (worksheets), it will look in the last row of the matching tab and place the date.
Example:
Main Sheet Project Tracker
Col A Col B Col C Col D Col E
John 214212 Dallas TX
Jane 213628 Houston TX(Formula, = if Col A matches worksheet, then in Col "A", last row, insert here)
Martha 244382 Memphis TX
Now the formula I've used work's great but as you will see , it is row specific:
Code:
=INDIRECT("'"&[@PROJECT]&"'!" & "A20")
I have tried using various "last row" codes but keep getting an invalid cell reference error. For example, I tried using,
Code:
=INDIRECT("'"&[@PROJECT]&"'!" &INDEX(A:A,MATCH(REPT("z",255),A:A)))
I'm stumped
