VBA code to search from different sheet > Copy the row > Paste on different sheet.

Hi All,

I am seeking your help on VBA code.

1. Currently i had a range of data in sheet1 ( A1:G4000 )
2. Sheet1 Col A1 are Unique alphanumeric code. ( Use to generate Barcode )
3. Under sheet2 A1:A4000 will be input, which user will scan the barcode.
4. Once the barcode scanned and input to range of A1:A4000, the cell will be uneditable with password protection.
5. If the same barcode being scanned again, it will not capture in range A1:A4000. Active cell will remain at the empty cell to be ready for input again.

Above is the function that will be in Range A1:A4000. Below is the trigger needed whenever the barcode scanned / the cell had input.

6. Whenever the Cell Range of A1:A4000 had a input, VBA will trigger and search over the Sheet1 A1:A4000. Once the Unique code searched, copy Bx:Gx and paste into the cell which under the same room of the Barcode being scanned. And finally the entire row will be protected ( If this option is not available, is ok ).


Appreciate that someone can enlighten me on this option with VBA. As i do not have any knowledge on VBA coding. Thanks