Excel 2007 : (Copy Data from sheet 1 to sheet 2) (Pasting Option)

**sunny1978** · 05-11-2010, 11:32 PM

I need help with copying data to sheet 2, there seems to be a problem with my macro it copy's data in sheet 2, but it always pastes data in A2 Row, B2, C2 and so on... I can't seems to understand what is wrong. (what should I do if I want the data to paste below A2 Row for example: A5, B5 or C5.

I use this macro in my work sheet

Option Explicit

Sub CopyData()
Dim NextRw As Long
Dim wsMn As Worksheet, wsIp As Worksheet

Set wsIp = Sheets("Input")
Set wsMn = Sheets("Main")
[NextRw = wsIp.Range("A" & Rows.Count).End(xlUp).Row + 1]

wsIp.Range("A" & NextRw).Value = wsMn.Range("N2").Value
wsIp.Range("B" & NextRw).Value = wsMn.Range("C6").Value
wsIp.Range("C" & NextRw).Value = wsD.wsMn("J5").Value

End Sub

**JBeaucaire** · 05-12-2010, 12:36 AM

Hi Sunny... Welcome to the forum.

Be sure to read through the Forum Rules so you can use and follow them effectively. For instance, you'll need to EDIT that post above and put code tags around that code you used. (Like shown here) Please go back and fix that.

Try this:

Please Login or Register  to view this content.

There's also an error, you didn't change one of the wsD reference when you adjusted my macro for your use, you need to adjust all the references.

**sunny1978** · 05-12-2010, 01:51 AM

Hi, JBeaucaire,
sorry for the misunderstanding..
you didn't understand my question...

I tried the code you posted, but it's not helping, its still doing the same thing.
its still pasting data in sheet 2 in the second row..a2, b2, c2

[NextRw = wsIp.Range("A" & wsIp.Rows.Count).End(xlUp).Row + 1]

(My question was, I want the data to be paste in A5, B5, C5..)

Set wsIp = Sheets("Input")
Set wsMn = Sheets("Main")
[NextRw = wsIp.Range("A" & wsIp.Rows.Count).End(xlUp).Row + 1]

wsIp.Range("A" & NextRw).Value = wsMn.Range("N2").Value
wsIp.Range("B" & NextRw).Value = wsMn.Range("C6").Value
wsIp.Range("C" & NextRw).Value = wsMn.Range("J5").Value

End Sub

**Richard Buttrey** · 05-12-2010, 04:58 AM

Originally Posted by sunny1978

Hi, JBeaucaire,
sorry for the misunderstanding..
you didn't understand my question...

...and you didn't understand and respond to JB's request. Please go back and add code tags to your post.

Rgds

**sunny1978** · 05-12-2010, 08:01 AM

Hey I am sorry about that, I am very new to this forum, that's why I got confuse with that tag thing. I didn't realize what you exactly meant by tag. but OK I got it now.

Please let me know if I am still doing something wrong...

thank you for all your help..

**royUK** · 05-12-2010, 01:29 PM

Your thread is being closed for non compliance with our rules. Please PM me when you have read the forum rules RULES and made the changes to your post accordingly, i will then unlock your post so you may continue with the thread!

Post Closed