Hi Shanen

In worksheet A insert a Command Button from the Control Toolbox menu, then
right click on the button and select Wiew code.

Paste this code in the codesheet that appears:

Private Sub CommandButton1_Click()
Dim TargetCell As String
TargetCell = Range("A3").End(xlDown).Address
Range(TargetCell, Range(TargetCell).Offset(0, 5)).Copy _
Sheets("Sheet2").Range(TargetCell)
End Sub

Change "Sheet2" to the name of worksheet B i needed.
Close the VBA editor and hit Exit Design Mode button on the Control Toolbox
menu.

Now it's time to test it :-)

Regards,
Per

"Shanen" skrev i meddelelsen
...
Help. I have worksheet "A" and once the user has populated columns A4 -
F4
I'd like to have a button that says "Complete" and once they hit that
button
all the data from the above fields automatically populates worksheet "B"'s
same field numbers on the second worksheet.- same numbering schema - in
other
words the next person may have A5 - F5. How do I do this? is it even
possible?
Help
--
Shanen