Macro code for filling up data with respect to count of Next column

[purandhar]

Sample:
A B C D E
1 ani sq 250 33 450
2 111 22 222
3 444 44 222
4 123 12 899
5 122 34 113

Now i want to make a code that fills same data in A1 and B1 up to A5 and B5, If i have data in C,D,E column upto 100 count means i want the same A1 and B1 need to fill in upto the C column count... Can abybody help on this ??

 

[Joe4]

I am afraid that your attempt to post example data did not turn out well, so we cannot really get a good picture of what is going on. Posting data outside of code tags does not maintain spacing.
There are tools you can use to post images, mentioned in the Posting Aids section here: http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html

Also, if you are unable to use those, you can use Code tags around all your data to maintain spacing. There are also a few ways to see what your posting will look like before committing it to the thread:
- Use the "Test Here" forum to post it there first and see what it will look like
- Use the "Advanced Editor" and use the Preview button to see what it will look like before committing it (I use this with the Code Tags option, as you can keep going back-and-forth easily until you have it looking good).