Populate Values in a Worksheet Via a Submit Button in Another Worksheet.

[The Wamp]

I'm trying to populate values in a worksheet by way of a submit button in another worksheet which will involve data matching. Please see attached image for a better understanding of what I want to accomplish. I think what I want to achieve it is rather straight forward...It's the code where I am hitting a wall.

 

[My Aswer Is This]

If this something like you want.

Private Sub CommandButton1_Click()
Sheets("Alpha").Range("A1").Value = Sheets("Bravo").Range("C1").Value

End Sub

 

[The Wamp]

No. This is not working. Can you be more specific per the image attachment. As you can see, I'm laying out a build plan in the SPRP TOOL worksheet that I want to populate the corresponding item number and dates range in the KITS PICK SCHED worksheet which requires item and dates matching.