gleamng
Board Regular
- Joined
- Oct 8, 2016
- Messages
- 98
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- 2003 or older
- Platform
- Windows
- MacOS
- Mobile
- Web
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.
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.