I am using this formula:
=INDEX(1:1,MAX(INDEX(COLUMN(1:1)*(NOT(ISBLANK(1:1) )),))) to get the last
non-blank value in my current worksheet. Does anyone know how to use this
formula to get the last rnon-blank value of a different workbook?

Thanks!