What is the EXCEL macro for such a task?

Question

Macros

Tab 1
Contains column A - in which SKUs
Contains Column B - in which potential SKUs
Contains Column C - in which potential SKUs Tab
2
Contains Column A - in which SKUs
Contains Column B - in which
SKUs
we insert articles into column A (Insert 1), in Tab 1 (columns B and C) potential articles from Tabs 2 (columns B and C) are put down.
The second tab turns out to act as a database.
The first tab, column A is the initiator.
We wrote down the article in A1 (first tab), the macro takes the values ​​B and C from tab 2 and copies (fills in) the corresponding data in tab 1.
Thank you.

Answer 1

You don't need a macro for this task
You need a VLOOKUP function