Excel Copy text code help needed

[steven10101989]

Hi

I currently have a worksheet called "Plan" where the user will enter text into "C34", once complete they will click on a form control button to email the spreadsheet.

I need help with code that would "copy" the text from "C34" to a worksheet named "Goal 1", position "C8" when the user clicks the form control button.

Any help would be greatly appreciated.

 

[Hui]

Steven

Firstly, Welcome to the Chandoo.org Forums

Sheets("Plan").Range("C34").Copy Sheets("Goal 1").Range("C8")