automatic cell update

[vani2004]

Sheet1
[TABLE="width: 200"]
<TBODY>[TR]
[TD]02/1/13
[/TD]
[TD]1400
[/TD]
[TD]25
[/TD]
[/TR]
[TR]
[TD]2/2/13
[/TD]
[TD]1400
[/TD]
[TD]54
[/TD]
[/TR]
[TR]
[TD]2/3/13
[/TD]
[TD]1400
[/TD]
[TD]35
[/TD]
[/TR]
</TBODY>[/TABLE]
Sheet2
[TABLE="width: 100"]
<TBODY>[TR]
[TD]date (ColumnA)
[/TD]
[TD]id (Column B)
[/TD]
[TD]sale (Column C)
[/TD]
[/TR]
[TR]
[TD]2/1/13
[/TD]
[TD]1500
[/TD]
[TD]120
[/TD]
[/TR]
[TR]
[TD]2/2/13
[/TD]
[TD]1500
[/TD]
[TD]94
[/TD]
[/TR]
[TR]
[TD]2/3/13
[/TD]
[TD]1500
[/TD]
[TD]185
[/TD]
[/TR]
</TBODY>[/TABLE]
Sheet3
[TABLE="width: 300"]
<TBODY>[TR]
[TD]ID
[/TD]
[TD]last sale
[/TD]
[/TR]
[TR]
[TD]1400
[/TD]
[TD]35 (Cell B2)
[/TD]
[/TR]
[TR]
[TD]1500
[/TD]
[TD]185 (Cell B3)
[/TD]
[/TR]
</TBODY>[/TABLE]

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))