Code for coping 1row of data to 2 rows

October 12, 2011 at 03:00:01
Specs: Windows XP
Source file:-

No Name Address City Contact
1 He Ammer Hyd 999
2 Re Hello Hyd 455
3 Ke Ram Che 111

Like that I am having so much of data in my excel file.I want to format the data in the below format using VBA Code.

1 He Ammer
Hyd 999
2 Re Hello
Hyd 455
3 Ke Ram
Che 111

Please help me out


See More: Code for coping 1row of data to 2 rows

Report •


#1
October 13, 2011 at 18:25:27
Please click on the blue line at the end of this post and read the instructions found via that link.

Then repost your example data using Row numbers and Column letters so that we can get a better understand of how your data is laid out and what results you are looking for.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question