Thanks for the help guys...

Another question relating to this, what would i need to add to the formula so that for example i scan the first barcode in a1 the cursor then jumps down to a11 scan that then jumps to a21 etc.. etc..

cheers for the help