Trouble cutting and pasting rows

Hi all,
I have had tremendous success using this forum for my VBA problems and I have scoured the forums for this issue but none of the solutions seem to work for me. I have a workbook that I am building to convert Quickbooks .csv invoices to a file that can be imported into a POS system. I have everything working except for this: I have 3 columns of data and around 2000 rows. After the previous codes run, I am left with POS item numbers, Warehouse item numbers and quantities. If an item is not in the POS system, it returns a "#N/A" error. I have code that copies and pastes only values back to the sheet. What I need is code to copy any row that has "#N/A" in column A and paste it into the next empty row on the next sheet and delete it from the original sheet.

I have tried a LOT of different solutions I've found in these threads but none will work for what I need. My set up is like this:

Sheet 1 is named "POS Import". Three columns, "Item Number", "Item Name" and "Quantity".
Sheet 2 is named "Misc Items". I just need the error items from the other sheet pasted into this sheet.

Any help would be greatly appreciated.

Please attach a sample with desire result.

Inventory Workbook Copy.xlsm Here is a copy with the invoice data already in place. The code in module 7 is where I am stumped. This is probably my 12th try at code I've found online. Thank you for taking a look.
The sheet "Misc Items" is where I need the error items from the "POS Import" sheet. The 2 rows would be the ones toward the bottom with "#N/A" in column A. Just want to cut them from this sheet and paste into the next sheet.

There are many ways of getting the result. I have assumed the errors are constant, i.e. they are not produced by formula.
If this is not the case, I will change the code in module 8.

If you want to delete the row

Please Login or Register  to view this content.