arange rows and groups by one column with macro

[rimvis]

Hi everyone,

I am asking for help making two macros:

1) first macro how to join or group rows No456 and another group rows No 789.
2) And another macro how to arange all rows, but group of rows have moved together to place there need them.

What I have:


A B C D

1 AAA1 BBB1 CCC1 DDD1
2 AAB2 BBC1 CCR2 DDA2
3 AAA1 BBC2 CCR3 DDA3
4 ARA1 BBA1 DCR3 DDD2
5 CRM2 DRM3 (Columns C and D)
6 CRM3 DRM4 (Columns C and D)
7 ARA1 BBB2 DCR3 DDD2
8 CRM1 DRM6 (Columns C and D)
9 CRM2 DRM5 (Columns C and D)


What I need:

A B C D

1 ARA1 BBA1 DCR3 DDD2
2 CRM2 DRM3 (Columns C and D)
3 CRM3 DRM4 (Columns C and D)
4 AAA1 BBB1 CCC1 DDD1
5 ARA1 BBB2 DCR3 DDD2
6 CRM1 DRM6 (Columns C and D)
7 CRM2 DRM5 (Columns C and D)
8 AAB2 BBC1 CCR2 DDA2
9 AAA1 BBC2 CCR3 DDA3


Renumber of rows I know how to do. Please help me

arange by column "B".

After grouping or joing (Somehow) those not full rows could be not visible for time then those are not use (its like group: you can push the button and they splits).

[arlu1201]

Its better you explain with the help of an attachment.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

If the 1st macro and 2nd are completely different from each other, its better you open a new thread for each. You can keep one question here and have another thread for the other macro.

[rimvis]

Thanx for notes,
i'll to remember it for the next time. the first macro is like the part of the secand one, just i need that codes of them would be not the same, becouse if i need to arange those rowse by date and if there will be a new rows for make a groups i need these cods would be separate of each other. Its will be For that i put in this thread two quastions, sorry. And Its would be to dificult to explane what i want for second quastion, becouse english is not first language for me please try help me

[rimvis]

Is anyone who know how to do these macro codes???

[rimvis]

Any suggestions would be much appreciated

[arlu1201]

Please do not bump your thread so often. Give others a chance to look through your question and work out a solution.

[arlu1201]

You need to explain question 1 more in detail.

Question 2 - How do you arrive at that pattern? What is the condition based on which you arranged the rows?

[rimvis]

question 2 - till a got extra data for those two rows like in example that attached I was yousing those macros:

a) for arrange rows by date, B column in attached file.
b) for arrange rows by name (by alphabet and numbers included), C column in attached file.

And that is the question how arrange these extra data with row above. My macros wich i used sorts rows one by one, for me after extra data are including is not good. To merge rows i think is not good idea becouse there are conditional formating in column c and b. they must work.