skaswani
01-04-2011, 10:42 AM
:banghead: :banghead: i m using Excel 2007
i want to write a VBA code
i have branches and branches post entries in core banking system, i have a task to perform, i have to create a MIS, actually required some data to be shifted in various columns
i.e
Posibility 1) SNG#123,Bill#200,Recepit#300
2) SNG123,Bill200,Recepit300
3) SNG123,B200,R300
4) SNG123,Bill200,Recepit300
5) SNG-123,Bill-200,Recepit-300
and if branch put some extra "spaces" it should truncate the spaces
ie.
6) SNG 123,Bill 200,Recepit 300
can i make a code if any of such combination to put or distribute the data into different columns
i.e
if description is in A column , B column should have SNG # , C column should have Bill # , D column should have Reciept #
please assist
Thanks
i want to write a VBA code
i have branches and branches post entries in core banking system, i have a task to perform, i have to create a MIS, actually required some data to be shifted in various columns
i.e
Posibility 1) SNG#123,Bill#200,Recepit#300
2) SNG123,Bill200,Recepit300
3) SNG123,B200,R300
4) SNG123,Bill200,Recepit300
5) SNG-123,Bill-200,Recepit-300
and if branch put some extra "spaces" it should truncate the spaces
ie.
6) SNG 123,Bill 200,Recepit 300
can i make a code if any of such combination to put or distribute the data into different columns
i.e
if description is in A column , B column should have SNG # , C column should have Bill # , D column should have Reciept #
please assist
Thanks