How can i import by defining a dictionary?

Hello everyone,

I have 2 Excel, one of which (Excel-OS) is programmed with VBA, and another Excel-Light (data) that is imported into the programmed Excel-OS.

Excel-Light consists of 2 columns, each referring to the type of product. One in English and one in German.

Excel-OS has only 1 column for the type of product. Now I want to insert a code in Excel-OS, that if in Excel-Light the English or German column is filled, then when importing (from Excel-Light into OS-Excel), the product type in Excel-OS is also always filled in German.

How can I do this by defining a dictionary?

FYI, cross-posted: https://stackoverflow.com/questions/...g-a-dictionary