Copy and Paste Macro needed

Hey Guys

I am a VBA rookie, and I can use help designing a Macro for work. There are a few steps I will need to accomplish so I will just take one step at a time.

First I need to be able to copy a particular part of a report and paste it onto another page.

In the attachment I need to copy the section where in Column K it says Canada. I will need to copy only Columns G to M for this section and for all the rows where Canada is in column K ( I have highlighted in light blue the section I need copied).

So essentially I need a macro to search for Canada in Column K and to create a selection box from K to M for only where there is Canada in column K. I will then need to paste this onto the another tab.

I have attached the document, any assistance is greatly appreciated, please let me know if I should clarify anything I have said.

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread. http://www.excelforum.com/excel-prog...ste-macro.html

Thread Closed.