Want to copy Data that meet criteria from one Datsheet to another

Good afternoon, I get a price list/Stock on Hand Sheet from my supplier everyday. I am writing macros to do various checks to ensure that no product that are no longer available are listed also that when new products are added I am notified, etc. I used to this manually with a vlookup formula and then filter it for the #N/A. I have written a macro for the Vlookup to loop and we are getting the result but now I want to copy all the rows, which have the #N/A next to it, into a new worksheet. I tried writing the macro with the filter in it and select the entire sheet and paste but this isn't very efficient.

Thanks
Brenton

Brenton:

Can you post the code you are using?