Macro to change CSV file

[elgato74]

Dear All

I have a csv file which I open in Excel and which I then need to be changed by a macro in the following scheme:

Column F needs to be copied and pasted into a new sheet in Column M,
Columns Y + Z need to be combined and then copied / pasted in C
AB > G
AC + AD combined > F
AF > J
AG > H
AH > K
AT > D
W > E

The csv file has a header row, which I do not need, so macro starts at Row 2

The filled new sheet needs to be saved as csv once the above transitions are done.

Attached sample csv which needs to be converted as described above.

Thank you in advance!

[jindon]

Try
You need to have one sheet named "Sheet1", before you run the code.

Please Login or Register  to view this content.

[elgato74]

Great! Thank you very much. Only these two are missing:

1 "Columns Y + Z need to be combined and then copied / pasted in C"

2 "Column F needs to be copied and pasted into a new sheet in Column M"

[bulina2k]

Hi Elgato

Do you think you can modify Jindon's code to adapt the last 2 requirements?
Do you need help understanding how the code works?

[elgato74]

Thanks. Do you?

[jindon]

Column F needs to be copied and pasted into a new sheet in Column M,
Columns Y + Z need to be combined and then copied / pasted in C
AB > G
AC + AD combined > F
AF > J
AG > H
AH > K
AT > D
W > E

I thought it was alright...

Change to

Please Login or Register  to view this content.

[elgato74]

now it is perfect thank you!