Return last completed cell in a column

  • Thread starter Thread starter Lori Lee
  • Start date Start date
L

Lori Lee

I have a column of dates(XX/XX/XX)some blank, others
filled in. How can I copy the last date that apprears in
the column to a new cell in another workbook?
 
One way, put this formula in the new cell

=LOOKUP(9.99999999999999E+307,'[Old Workbook.xls]Sheet1'!$A:$A)

replace the Old Workbook with the name of your source workbook and column A
with the date column of yours
 
Back
Top