Macro to search excel

Hello,

I'm trying to write a macro so when a number is scanned into Excel (using a bar-code scanner) it searches the sheet to check if that number is already there, it if is to highlight the cell the number is in and possibly throw up an error, if not for it to populate the next empty cell in the row and move to the next one.


Thanks