Copy information from the bottom
If the column contains numbers, then you need:
=LOOKUP(10^307,'Sheet1'!A:A)
If it contains text you need:
=LOOKUP(REPT("z",255),'Sheet1'!A:A)
The cell with this formula will always show the last value in column
A:A of Sheet1
HTH
Kostis Vezerides
thebaldsoprano wrote:
I am running a large purchase order log on excel 03. I would like to have the
information from the bottom of the log (the newest entry) copy to an actual
purchase order on another worksheet in the same workbook. This way I could
print off an order after I enter each log. Since the bottom of the log is
always going further down is this possible? And is it possible for this to
work vice versa?
Thanks!
|