I have one column of 69888 rows. I want to write a macro to divide this column in to multiple columns, each consisting 26 rows.
How can I do so? Please Help.
I have one column of 69888 rows. I want to write a macro to divide this column in to multiple columns, each consisting 26 rows.
How can I do so? Please Help.
Last edited by mithil; 10-21-2010 at 04:21 PM.
Assuming all that data is in column A, give this a try:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thank you..........
This works... :D
Can we have pop-up box asking for the number of rows up to which the data can we limited in each column with the help of macro above?
sunnyboy.online8,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks