Here is the code...

Sheets("Sheet2").Range("F2").value = Sheets("Sheet1").Range("A1").Value

Do you need help creating a button and adding the code to the button?
--
HTH...

Jim Thomlinson


"cityfc" wrote:

I have a name on sheet1 in cell a1 and when i click a button i want the
contents of a1 pasting to f2 on sheet 2

Thank You for your help in advance.