I have an excell workbook that I am looking to copy data from cell "A1" in sheet1 to a new cell in row "A" in sheet2 on a commandbutton_click. can anyone show me the method or best way to accomplish this. I am affraid that I have not had a formal class in vba so any help would be apreciated.

using excel 2007