• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macros to paste data in another worksheet on the next row

Wreckz

New Member
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 <<<
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
your help would be appreciated.
 
Last edited by a moderator:
Wreckz
As a new member, You should reread Forum Rules
You seems to skipped few basic things.
Try to focus to How to get the Best Results at Chandoo.org
 
Back
Top