Copy & paste with specific condition to destination sheet

Hi all,

I have been looking for the below requirement for past 5 hours but I couldn't find it. Below are my requirement.

1. I want to copy the data (Column A to E) from the Sheet "Raw" to "Summary" but I want to copy paste the details based on the numbers provided in the table from Column I to K.

Eg. As per the table, if the country is IN and the entity code is lesser than 5000 then i should copy the first single entries to the "Summary" Sheet.
Note: The details provided in the table (Column I to K) is constant, it will not change.


2. Here my challenges starts, I should copy paste the line items as per the count provided in the table.

Eg. I should copy and paste only 2 EUR line items which has the entity code between 5000 to 20000 but my data (Column A to E) may or may not have more than 2 EUR line items but I should copy and paste only the first line 2 items in the summary sheet since that is my requirement.

3. My second challenge, some times those country details will not be available in the data (Column A to E) so during those scenarios i should skip that case and move on to the next country.

I have pasted my desire output in the summary sheet. Please assist me to resolve it.

Try attached file: Can't post code. System thinks it contains HTML

Hi Minicab,

Thanks a lot. It is working perfect. but one condition is not working.

I should copy paste the data as per the count provided in the no. of entries in Column K.

Eg. I should copy and paste only one line item for the country IN since it is mentioned as 1 in the No. of the entries column in Column K and same goes for EUR wherein I should paste 2 entries and for NAM I should paste 5 entries.

also Eg. NAM has 5 entries should be pasted to the summary but in some scenario i may have lesser than 5 during those scenarios I should paste whatever having lesser than 5.

Hi Nankw83,

Thank you for your valuable time but i am not getting my desired output as per the changes done in your attached file.

Eg. while copy the EUR details you have mentioned it to copy Range from (A1 to E3) but i need to copy only the visible cells after filter.. Those visible cells may appear at row 17 or 18 or 21.

Hi Nankw83,

Thanks a ton.. it works greatly.. but please let me know the purpose of Column 6.clear contents.

For thoroughness, I completed the requirements. But Nankw83 solution is much more efficient

Please Login or Register  to view this content.

Hi Maniacb,

will try it out your method as well. .thank you so much for your time.

Hi Revathi,

Your file structure in post #10 is different than your sample file in your original post & that's why the provided code in post #4 is not working properly. In addition, the code is using Advanced Filter where the destination sheet fields should exist in your source data - "Total" column is not. Lastly, the way you set up your filter list in sheet "List" is not correct. I suggest that you read a little about Advanced Filter HERE to understand how to set up your filter (this doesn't require VBA knowledge) & once you do, you can alter my code above to make it suite your revised file

Hi Nankw83,

Sorry for the confusion. i have gone thru the article but even i am not able to find my answer. Please assist.

1. I will go with as per my Old sample file wherein i have a condition that i need copy paste the first 2 visible rows after filtering the EUR country where the weight between >=5000 to <=20000. Only this condition is not working. I have highlighted the result in the summary sheet.

Different method

Please Login or Register  to view this content.