Copy range to other sheet depending on entry in cell

Hello,

I recently discovered VBA.
I want to write values froms cells C4:C10 to another sheet, depending on the number given in C2.
On the next worksheet (ws2), I have number 1 to 10. If the number in the first row is the same as given in C2, then the values (C4:10) need to be copied in the cells below that number.

I already got a code to find the the same number:

Please Login or Register  to view this content.

Many thanks! *How can I add an attachment to this post?
screenshot excel test.png screenshot excel test2.png Test.xlsm

Try:

Please Login or Register  to view this content.

and please edit your post to comply with http://www.excelforum.com/forum-rule...rum-rules.html by using code tags

As Destination is first (and only) parameter in Range.Copy method name of the parameter can be skipped, so

Please Login or Register  to view this content.

is exactly the same as:

Please Login or Register  to view this content.

see how you use MsgBox - for instance you wrote:

Please Login or Register  to view this content.

extended version would be:

Please Login or Register  to view this content.

---------------

Glad it worked, and also from code tags usage in post #3. What I asked before (and ask again) is to push "Edit Post" button below your first post and use code tags also there.

PS. As you have action for both "found" and "not found" have a look on soch "inversion" in the code:

Please Login or Register  to view this content.

I added also second (optional) parameter to MsgBox to emphasize that it is a warning message

Glad to hear that.
So if that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.