Dear all,

I am new in the VBA programming world. I am training my self in creating xls files from csv file with VBA.
Can someone help me with the following dilemma. Your help is highly appreciated. Thanks in advance!!

I have the following csv file with one column and six rows:

, , , House, Price
Nr, Owner, Time, Type, Euro
1,Yes, 0.5, A, 10
1,Yes, 1, B, 15
2, No, 0.5, C, 20
2, No, 1, D, 25

I want to split this csv file into two xls worksheets. One worksheet has only values for Nr 1 and the other worksheet has only values for Nr 2. Furthermore, each worksheet has two sheets: House and Price.
In short I want to to import the csv file into 2 excel worksheets with each 2 sheets

xls. Worksheet with only Nr. 1 and two sheets House and Price
Sheet= “ House”

Nr 1 1
Owner Yes Yes
T 0.5 1
Type A A

Sheet= “ Type ”

Nr 1 1
Owner Yes Yes
T 0.5 1
Euro 10 15

Worksheet with only Nr. 2 and two sheets House and Price
Sheet= “ House”

Nr 2 2
Owner No No
T 0.5 1
Type C D

Sheet= “ Type ”

Nr 2 2
Owner No No
T 0.5 1
Euro 20 25

Can somenone help me with a VBA code to do this? Thanks!