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 to perfor
calculation.

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

Thanks
Michae

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

With Worksheets("Sheet1")
Worksheets("Sheet2").Range("A2").Value =
.Range("K" & Cells(Rows.Count,"K").End(xlUp).Row).Value
Worksheets("Sheet2").Range("A3").Value =
.Range("L" & Cells(Rows.Count,"L").End(xlUp).Row).Value
End With

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Michael168 " wrote in 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 to 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/

Are you looking for a formula or vba code.

Are the values numeric or text?

--
Regards,
Tom Ogilvy


"Michael168 " wrote in 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 to 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/

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

A2: =INDEX(Sheet1!K:K,MATCH(9.99999999999999E+307,Shee t1!K:K))

A3: =INDEX(Sheet1!L:L,MATCH(9.99999999999999E+307,Shee t1!L:L))


If column K (or L) is blank, it will return #N/A

--
Regards,
Tom Ogilvy

"Michael168 " wrote in message
...
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 in
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 to
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/

Tom:
The row argument within the Match() function below is:
9.99999999999999E+307 <<?? This evidently is computereeze for a real
row-number.
What does it equate to?
TIA,
JMay

"Tom Ogilvy" wrote in message
...
A2: =INDEX(Sheet1!K:K,MATCH(9.99999999999999E+307,Shee t1!K:K))

A3: =INDEX(Sheet1!L:L,MATCH(9.99999999999999E+307,Shee t1!L:L))


If column K (or L) is blank, it will return #N/A

--
Regards,
Tom Ogilvy

"Michael168 " wrote in message
...
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 in
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 to
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/

It is the largest number Excel can store. It doesn't have anything to do
with a row number . Match returns the row number.

--
Regards,
Tom Ogilvy

"JMay" wrote in message news:ksLrc.2979$zE6.107@lakeread06...
Tom:
The row argument within the Match() function below is:
9.99999999999999E+307 <<?? This evidently is computereeze for a real
row-number.
What does it equate to?
TIA,
JMay

"Tom Ogilvy" wrote in message
...
A2: =INDEX(Sheet1!K:K,MATCH(9.99999999999999E+307,Shee t1!K:K))

A3: =INDEX(Sheet1!L:L,MATCH(9.99999999999999E+307,Shee t1!L:L))


If column K (or L) is blank, it will return #N/A

--
Regards,
Tom Ogilvy

"Michael168 " wrote in
message
...
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 in
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 to
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/