copy from sheet1 and paste to sheet2

copy from sheet1 and paste to sheet2
this yellow colour I have putted it is just for understanding  purpose, in this yellow colour I have data
I have to copy paste this by vba
kindly see the attachment
Book2.xlsm
Avinash SinghAsked:
Who is Participating?
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You may try something like this and tweak it if required.
Sub CopyData()
Dim sws As Worksheet, dws As Worksheet
Dim RngToCopy As Range, destRng As Range

Application.ScreenUpdating = False

Set sws = Sheets("Sheet1")
Set dws = Sheets("Sheet2")

Set RngToCopy = sws.Range("D6:K14")
Set destRng = dws.Range("F8")
RngToCopy.Copy destRng

Application.ScreenUpdating = True
End Sub

Open in new window

0
 
Avinash SinghAuthor Commented:
Thnx again Neeraj sir for giving ur precious time to my post
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome Avinash!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.