csv macro

[gleamng]

Good evening everyone here,
i need your help with a macro
i want the macro to split the CSV value in the column D into different column
also i want the macro to look through the column create heading for each deductions separately (i.e. is should create a column for all deduction type that appeared in column D - NHF, TAX, NASU etc), then put each figure i its respective column without the "N" before the figures.
again i want the column to be inserted after column D

thank you all for your anticipated support, as i hope to hear from the forum soonest.

thanks all.

 

[gleamng]

Good evening all, i don't have any knowledge about VBA, please help me with the above.
Thank you all