Sorting an excel in a custom way

Question

0.00/5 (No votes)

See more:

Hi,
I want to creat a userform in excel macro. which on clicking will sort the excel.
I have an excel in a following way.

COL-A COL-B
1     q
1     a
1     a
1     g
1     l
1     t
2     i
2     j
4     p
4     f
5     y
5     x
6     m
7     b

I want to sort it in the following way.

COL-A    COL-B    COL-C    COL-D    COL-E    COL-F   COL-G    COL-H
1          q        a        a        g        l       
           t

2          i        j

4          p        f

5          y        x

6          m       
 
7          b

as seen 1 is appearing 5 times in columb-A so whatevery values are corresponding to
1...should be arranged in diff columb but max 5 columb should be used. likewise the other columbs

[edit]SHOUTING removed - OriginalGriff[/edit]

Posted 31-Aug-12 0:31am

Avinash.aswani

Updated 31-Aug-12 0:34am

OriginalGriff

v2

Add a Solution

Comments

OriginalGriff 31-Aug-12 6:34am

DON'T SHOUT. Using all capitals is considered shouting on the internet, and rude (using all lower case is considered childish). Use proper capitalisation if you want to be taken seriously.

Mehdi Gholam 31-Aug-12 7:47am

Very strange way to do things, why?

ZurdoDev 31-Aug-12 8:25am

You can start a loop counter at 1 and go to cell A1. Then get its value and copy to B on another sheet. Then go to row 2 in your loop and if the value is the same, copy to column C. Just use variables to keep track of when things change and what column and row to right to. It shouldn't be that bad.

Avinash.aswani 31-Aug-12 9:29am

ya ur correct thats what i also wish to do. but i dnt knw macro coding. Can you help me with it?

ZurdoDev 31-Aug-12 9:55am

The easiest thing to do is to record a macro doing at least part of what you want. That will get you started and then I can help. What version of Excel is it?

Avinash.aswani 31-Aug-12 10:50am

Its Excel 2010. and will recording macro work? coz we have conditions here.

ZurdoDev 31-Aug-12 11:02am

Recording a macro will help to get you familiar with the object model. For example, reference cells by Sheets(”SheetName”).Cells(i, j) and then use i and j in your loops.

Avinash.aswani 4-Sep-12 2:37am

Hi,
I tried using the record macro option. but am not able to do looping. and ya i am new to programming. so it would be usefull if u can help me with the code.

Joan M 4-Sep-12 6:30am

Try it and improve your question with what you've done. Then we will be able to help.

Avinash.aswani 31-Aug-12 9:27am

ya its strange...but its a requirement. And i dnt know much coding.If u can provide me with the code it'll be good and great help, i can modify or make small changes if required..

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Avinash.aswani · Answer 1 · 2012-09-04T00:26:00

Solution 1

Guys please help me with the code if possible it wil be a great help

Posted 4-Sep-12 0:26am

Avinash.aswani

Comments

Joan M 4-Sep-12 6:29am

Putting an answer to your question is like shooting to your own foot.
Now your question looks already answered and plenty of people won't look at it...
I've reported your answer as not being one, you could delete it already to gain time.