Hi, Tom

The values are in numeric
I am looking for a formula.
Thanks to Bob Philips for the VBA code.

Regards
Michael

Tom Ogilvy wrote:
*Are you looking for a formula or vba code.

Are the values numeric or text?

--
Regards,
Tom Ogilvy


"Michael168 " wrote i
message
...
I have a workbook with 2 sheets.
Sheet 1 contains the values which be updated daily.
Sheet 2 uses to get the values from the last row of sheet 1 t
perform
calculation.

My question is how to make A2,A3 of sheet2 always get the value of
column K,L of the last row in Sheet 1?

Thanks
Michael


---
Message posted from http://www.ExcelForum.com/


--
Message posted from http://www.ExcelForum.com