macro help

[discodave]

hi im creating a booking system for a takeaway

i have a worksheet called 'place order' which has numbers in colum B, food in colum C, and prices in columD between rows 3-49
i need a macro so that when a button is clicked, if the number in columB is more than 0, BCD are copied onto another worksheet named 'Receipt' for that row. i also need the copied rows to form a list.
i have no idea where to even start with creating a macro that will do this, help would be greatly appreciated

thanks

 

[discodave]

anyone know how to do this?

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/showthread.php?t=537582

I merged the replies from the two threads together.

Please do NOT post the same question multiple times. Per forum rules, such threads will typically be locked or deleted.

Also, I would recommended waiting for more than 10 minutes before bumping your own posts and here is why. This is an option under "Quick Links" to view "Unanswered Threads". Many of us here use that to look for unanswered questions that need responses. Once you reply to your own post, it no longer shows up on that list. So you should wait at least a few hours before bumping your own posts. If you are not getting any responses, it may be a sign that your question is not clear.