How to write data from sheet 1 to sheet 2

[ppr (Peter Preuss)]

there are several options to do it.

We can use sheet1 data and create for us a lookup data dictionary:

then we can use for sheet2 a dtData2.NewRow for getting an empty row within the Sheet2 Schema which we can populate with the help of the lookup data dictionary