Home » Forums » Open Source Learning Center » Question and Answer

Insert start and finish between data

Submitted by djfscouse on 15 February, 2013 - 22:35

Hi,

Is it possible using VBA to insert and before and after a set of data.

Example:

Beginning data

71723,121222010,EXAPLECOMPANY,2-13-2013,
71723,121222010,EXAPLECOMPANY,2-13-2013,
71721,121221142,EXAPLECOMPANY,2-13-2013,
71718,121234503,EXAPLECOMPANY,2-13-2013,
71718,121234503,EXAPLECOMPANY,2-13-2013,
71720,121238748,EXAPLECOMPANY2-13-2013,

After VBA


71723,121222010,EXAPLECOMPANY,2-13-2013,
71723,121222010,EXAPLECOMPANY,2-13-2013,


71721,121221142,EXAPLECOMPANY,2-13-2013,


71718,121234503,EXAPLECOMPANY,2-13-2013,
71718,121234503,EXAPLECOMPANY,2-13-2013,


71720,121238748,EXAPLECOMPANY2-13-2013,

Thanks for any help or advice,

David

‹ Sum amount based on same reference id Custom Formula ›
»
Shane Devenshire's picture

Need more info

Submitted by Shane Devenshire on 17 February, 2013 - 20:04.

Hi,

As written your question is unclear to me, please provide additional clarification.

Thanks,
Shane

»