Copy and paste the data VBA Code

[Jerry57]

Hi,

Hope you are doing good. I needed your help in the attached sample file.

Once user enters the D4 to D7 information and should click on submit button
As soon as submit button is clicked, I wanted the data to be transferred to sheet called "Data" and information in the "Input" sheet should cleared

 

[Belleke]

Like this?

 

[Marc L]

Hi, according to initial post attachment an Excel basics VBA demonstration :​

Sub Demo1()
    If [COUNTA(D4:D7)<4] Then Beep: Exit Sub
    Sheets("Data").Cells(Rows.Count, 1).End(xlUp)(2).Resize(, 4) = [TRANSPOSE(D4:D7)]
    [D4:D7].ClearContents
End Sub

Do you like it ? So thanks to click on bottom right Like !​

​

 

[Jerry57]

Like this?

Awesome, it works just the way I wanted it, thank you so much....

 

[Belleke]

Glad to help.