Split Delimited nth Data into New Rows/columns

Hello All

i have made sample, in sheet 1 is the data and i want result like in next sheet,(i made limited result as per sheet 1 it will be more) & next sheet also generate with code.!!


Adeel

Please Login or Register  to view this content.

thanks a lot Jindon, this is great outclass staff
little change that next sheet auto generate with result please

Adeel

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

thanks a lot Jindon, you are champ

Hi jindon
i found some issue that code isn't pick amount in negative and also which has dots like 983.58, please review sheet 4 yellow highlighted

Adeel

thanks a lot Jindon, now its working fine thank you so much