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

[gkzeta]

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 <tbody> </tbody>

<tbody>
</tbody>