Hi Excel Community,
I'm trying to create a submit button that pastes the data in another worksheet, but it creates it on the next row after every entry.
Here's my code so far:
>>> use code - tags <<<
your help would be appreciated.
I'm trying to create a submit button that pastes the data in another worksheet, but it creates it on the next row after every entry.
Here's my code so far:
>>> use code - tags <<<
Code:
Sub Submit_DST()
'
' Submit_DST Macro
'
'
Range("C33:BG39").Select
Selection.Copy
Windows("Test.xlsx").Activate
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Windows("DCA 1 DST - New.xlsm").Activate
End Sub
Last edited by a moderator: