Return last completed cell in a column

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?
 
P

Peo Sjoblom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
First Day of the month 3
cell reference question 2
Countif or Sumproduct 2
Drop-down calendar for sheet 0
Space at end of multi page list to accommodate new entries 1
Sum data in a column if multi creteria met 4
What formula do I need? 3

Top