Copy horizontal range and paste into other sheet if column contains word

Hello Everybody,
I want to copy only specific cell i.e. not entire row if column contains specific word i.e. NA..

So in your Sheet, NA appears twice.

So all you want is NA to be pasted twice? Is that right?

I want all NA to be selected in column and past in output sheet

Put this in the Output sheet and drag down and across..

Please Login or Register  to view this content.

Actually it is making xl workbook heavy and getting slow... so it is required to copy only few cells..

Otherwise let me know the code for counting NA in column... I will make code accordingly with vlookup in Output Sheet

Something like this -

This is a Recorded code I edited later, so some scope for improvement..

Please Login or Register  to view this content.

ok.. I thought about auto filter... Easy way.. What is this Screenupdating..

That is awesome apo....

Screenupdating prevents your screen from flashing, and speeds up your macro..

Ok.. Thanks You..