Copy Rows to other worksheets

You have created lots of confusion by posting on many threads.

I replied to this thread with out checking the OP.

http://www.excelforum.com/excel-gene...ific-data.html

snobl01,
This is the correct post. I have attached the code and follow the above link.

Thanks for the guidance here!! for me it is very intimidating!! I did read the rules but was unclear how to start a thread so thought I would take a chance someone would guide me. I tried the file that you sent, it is very close just a couple things I forgot to request. If there is an "NR" in column "I" then copy to sheet2 also if I run multiple times it will not add duplicate entries. Again thanks a lot.

I am not sure how you want to handle the duplicates.
One way would be to clear the existing data in sheet2 and then re-populate it with fresh data

That would be fine. The file is supplied is just a sample my actual file is going to be hundreds of rows and several more columns. If you do not see an issue with clearing and re-populating everyday then that's fine with me.

Also the file you did copies all the rows between the actual rows that I want. So if I choose rows 2 and 6 with "NR" it will copy row 2,3,4,5,6.

It seems to copy all rows down to and including "NR" row. When I only need the row that has the NR. The "NR" only tells me "No RMA" so sheet2 will reflect all rows that do not have an RMA.

Okay!
Since row 2 is blank, the filter was not working. I have now corrected it.

I have also added another different code (Below filter code) which does not depend on filter. It is flexible and works with any data format.

You my friend are a genius!! That is exactly what I need. Thanks