automatic cell update

[vani2004]

Sheet1

02/1/13	1400	25
2/2/13	1400	54
2/3/13	1400	35

<TBODY>
</TBODY>

Sheet2

date (ColumnA)	id (Column B)	sale (Column C)
2/1/13	1500	120
2/2/13	1500	94
2/3/13	1500	185

<TBODY>
</TBODY>

Sheet3

ID	last sale
1400	35 (Cell B2)
1500	185 (Cell B3)

<TBODY>
</TBODY>

On Sheet3, I want Cell B2 & B3) to updated automatically from Sheet 1 & 2 (column C as row get added daily). Let say employee add another row to sheet 1 with (date: 2/4/13; ID: 1400; Sale: 100), i want Cell B2 in sheet 3 to update automatically to 100.

I appreciate your help - Thank you

 

[Nathan_Excel]

In sheet 3, put the following =INDIRECT(ADDRESS(COUNTA(Sheet1!C:C),1))

 

[Nathan_Excel]

Sorry, the 1 should be 3, i wrote it using the update being in column A, hence the 1, so INDIRECT(ADDRESS(COUNTA(Sheet1!C:C),3))

 

[vani2004]

Hi Nathan, it's showing 0 (Zero) - not pulling correct value

 

[vani2004]

ok Problem solved. I appreciate your help very much. I used following formula
=INDEX('sheet1'!C2:C9999,MATCH(9.99999999999999E+307,'sheet1'!C2:C9999))