Importing data into Excel files.

Guys, can you help me with code?
I don't understand where mistake is.

Please Login or Register  to view this content.

So, after start, data was imported incorrect.

фор.PNG

But this screenshot shows the correct imported data.

sOKDvu49EeeFrgryCjqNWg_37e85d2f574f2183de23c99a831f687b_ralphie-reactor-result.png

This is example of data which was imported.

Attachment 691683

You should change this line: S(i, j) = awb.Sheets(1).Range(ImportRange).Cells(i, j)
to: S(i, j) = awb.Sheets(1).Range(ImportRange).Cells(j, 1)

Greetings!!!

were you able to solve this? can you help me?