Microsoft Excel. How to make a transfer through 2 cells?

Question

excel

Good day comrades. I ran into an implementation problem:
1) we have a manual barcode scanner.
2) we have the most common exel table. It is
necessary that after the first scan the line goes to the right (tab), then I do the next scan and the line should go down (enter)
I ask for advice since I am wooden in exel.

Answer 1

Macro.
Advice, based on your knowledge of Excel: order for money. Forums with a section like "paid macro order" are easy to google.
UPD. There are ready.
excelvba.ru/programmes/BarcodeScanner