Copy and Paste Macro

Its okay, I can modify the code so it can be used in the original file. Do you know how to do what I asked with the example I have given?

canada will be in the cells of a particular column

Can we use my example from the other thread?

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.

Wow, Thanks so much it works very well.

I was wondering can this code be modified so it takes two criteria? What If I want to copy a section that has "Canada" in column K AND "1550" in column G.

I ask because in my report I will have other sections that has Canada in K but not 1550 in Column G and I do not need to copy these sections.

Thanks for all your help.

Actually I was able to figure that on my own. All I had to do was include an "AND" function.

Now I am wondering how do I paste the copied box into a particular section in my "paste" worksheet?

Lets say I want the copied box to be pasted starting at speficially B10? So we can no longer use the "Range("A" & Rows.Count).End(xlUp).Offset(1, 0)" part of your code, how can I tweak this so it will be pasted starting at a particular cell of my choosing.

Hey Arlu

Actually that would not quite work. Though in the example I used the "paste" worksheet is blank. In actuality the worksheet I use will have particular sections I will need to paste in order to calculate the OH charges. I have attached the excel file of where I actually need the values pasted. I need the section that the macro you have written will paste exactly in the cells A11:G25 section in the worksheet "Payroll OH Alloc Calc June" worksheet.

Basically paste the copied section under where it says "COPY AND PASTE TO CLEAN COPY OF RAW DATA".

Thank you!!


P.S.
There will more sections I need copied and pasted on other sections in the worksheet "Payroll OH Alloc Calc June", however I am sure I can figure out how to modify your codes to do that.

Thank you so much. The macro works perfectly. I am going to have to review it thoroughly in order to really understand how it works. But your help is greatly appreciated and will make work a little easier for my department. Thanks again and if there is any feedback or comments you would need me to leave please let me know.