challenging macro to copy specific data from workbook to save it to a new file csv ms dos

[RAM72]

Hi,

I have a workbook with several sheets, among one is named is CSV REPORT

looking for a macro to create a workbook with one sheet and save the data in text format in CSV MS DOS on desktop.

On creating the csv file format the macro should insert in column A1 HDR and A2 ITM1 however ITM1 should be copy to last data row
copy data I2 from CSV REPORT insert Column B 1
copy data J2 from CSV REPORT insert Column C 1
copy data K2 from CSV REPORT insert Column E 1
copy data L2 & M2 from CSV REPORT insert Column J2& K2
copy data A2 & B2 from CSV REPORT insert Column C2& D2 still to last data row
copy data C2 from CSV REPORT insert Column I2

In new workbook in csv msdos column B2 to insert 1,2,3 to last data row

save file from column N2 to csv report
How can't load csv file format upload as xls file a better understanding

HDR1,20MI130103/JL,20379138,,EUR,,,,,,,,
ITM1,1,39172900,TUBE,,,,,CN,NKPK,1,57,830
ITM1,2,39173300,HOSE,,,,,CN,NKPK,1,10,35
ITM1,3,39173900,COMPRESSOR HOSES,,,,,IT,NKPK,1,8,75
ITM1,4,39173900,FLEXIBLE PIPE,,,,,FR,NKPK,1,4,8
ITM1,5,39173900,SANITARY FLEXIBLE,,,,,CN,NKPK,1,3,16
ITM1,6,39173900,SANITARY FLEXIBLE,,,,,FR,NKPK,1,2,22
ITM1,7,39174000,GARDEN HOSE FITTINGS,,,,,CN,NKPK,1,200,160
ITM1,8,39174000,SANITARY PIPE FITTINGS,,,,,FR,NKPK,1,6,15
ITM1,9,39174000,WASTE SANITARY PIPE FITTINGS,,,,,FR,NKPK,1,37,137
ITM1,10,39181000,VINYL FLOOR COVERINGS,,,,,DE,NKPK,1,60,972

Actually doing this manually

Can anyone help

 

[Marc L]

Hi !​

Actually doing this manually

Just activate Macro recorder before to operate,
you will have a free code base !
​

 

[RAM72]

Hi !​

Just activate Macro recorder before to operate,
you will have a free code base !
​

OK I will make a try