D Denise Jan 3, 2004 #1 is there a function to have the last entry in a row on sheet1 to auto-populate to a designated cell on sheet 2?
is there a function to have the last entry in a row on sheet1 to auto-populate to a designated cell on sheet 2?
V Vasant Nanavati Jan 3, 2004 #2 In the designated cell on Sheet2, use this array formula: =INDEX(Sheet1!15:15,MAX(NOT(ISBLANK(Sheet1!15:15))*COLUMN(Sheet1!15:15))) entered with <Ctrl> <Shift> <Enter>. This assumes you want the last entry in row 15 on Sheet1. No doubt there are easier ways.
In the designated cell on Sheet2, use this array formula: =INDEX(Sheet1!15:15,MAX(NOT(ISBLANK(Sheet1!15:15))*COLUMN(Sheet1!15:15))) entered with <Ctrl> <Shift> <Enter>. This assumes you want the last entry in row 15 on Sheet1. No doubt there are easier ways.
