• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to copy some specific rows after filter the data

Not open for further replies.


New Member
Hello All,

i am recently learning excel macros and VBA.
I want the solution from you for my Doubt.
I have 2 excel workbook which are macros and 1 excel is filtered.
Normally what we have to do in the workbook 1 copy the 2 column value and filter it in the Workbook 2
this process is done. if one col contains <100 text in the sentence copy that particular row values and paste it into workbook 1
i tried but its not getting can you please suggest the answer.


This is the reference if 5 col contains <100 in the sentence copy the 3rd col in the specific row and copy 6th col value in that row
Not open for further replies.