Running a search macro - Need an alternative "if item not found."

Hi!
I'm creating a workbook with one sheet of data, another sheet to insert a list of item numbers of which data needs to be extracted, and a third sheet which is supposed to neatly display the data. I'm using Excel's search option to find the specific data row in the "Data" sheet, but if it searches for an item that is not stored in the data sheet, I want it to paste the missing item number into an alternate location for later review. If someone can give me the code or refer me to this kind of coding material I'll be grateful. Attached is the file and following is my code as well.

Example:
Let's say in the "List" sheet, I insert ten item numbers. One of them may be missing in the "Data" sheet if not recently updated. When this code runs, the Run-time error '91' comes up at the missing item number. At this point I want the missing item number pasted into the "Print" sheet in column G for later review, and then continue the loop through the rest of the items.

Any help will be greatly appreciated!
Orlando

Please Login or Register  to view this content.

Hi

Here goes.

Please Login or Register  to view this content.

rylo

Hi Orlando,

Try this code - works for me.

Regards, J450n

Please Login or Register  to view this content.

Sorry Orlando,

I modified the above slightly to get it to work but pasted the pre-modified code!

Try this:

Please Login or Register  to view this content.

Hi -

also try;

Please Login or Register  to view this content.

Regards,
Event

Thanks Rylo! Just what I needed!