Find and copy the last cell with function to another sheet in excel using macro.

[gkzeta]

[TABLE="width: 99%"]
<tbody>[TR]
[TD][TABLE="width: 100%"]
<tbody>[TR]
[TD]I'm trying to do the following:
I have 3 worksheets A, B and C.
In worksheet A, I have dates, names and corresponding values,
in the sheet B I have names and the total that each one has, i.e. the following act e.g. = b2 from sheet A gets the data, and in sheet C I want for a name to display the corresponding last entry from sheet B.
I do the code in visual basic and it shows me the date but does not show the Total, which is equal to a cell from another task sheet. If I replace my cell with number it shows the last number but I want to display the last cell which is equal to = b2 from another sheet.
The code, which I use, is:
sheetA.Range("a" & Rows.Count).End(xlUp).Copy
sheetC.Cells(3, 1).PasteSpecial xlPasteAll
Range("c" & Rows.Count).End(xlUp).Select
sheetA.Range("c" & Rows.Count).End(xlUp).Copy
sheetC.Cells(3, 3).PasteSpecial xlPasteAll[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
​