Cut Paste macro required

[JAVEDR]

Hello,
Steps below-

1. Required to sort column A, B, C & D
2. After sort Ankur entries in Column B need below Ravi entries in Column B.

Thanks for your suggestion's and reply

1	Header	Header	Header			1	Header	Header	Header
2	Data1	RAVI	AAA			2	Data1	RAVI	AAA
3	Data2	ANKUR	BBB			4	Data3	RAVI	AAA
4	Data3	RAVI	AAA			3	Data2	ANKUR	BBB
5	Data4	ANKUR	BBB			5	Data4	ANKUR	BBB
6	Data5	VIVEK	CCC			6	Data5	VIVEK	CCC
RAW DATA						REQUIRED RESULT

 

[davesexcel]

try something like

With ActiveSheet
       With .Cells(1, "B").CurrentRegion
.Cells.Sort Key1:=.Range("D1"), Order1:=xlAscending, Key2:=.Range("B1"), Order2:=xlAscending, Orientation:=xlTopToBottom, Header:=xlYes
       End With
End With

 

[JAVEDR]

Hi dave thanks for your reply, code is working find on example data but not working on original data,

 

[Peter_SSs]

2. After sort Ankur entries in Column B need below Ravi entries in Column B.

From your image it looks like Ankur & Ravi entries are in column C not B. Assuming they are in column C, try this (with a copy of your data) but everything is a bit vague.
Your image in post #3 shows us absolutely nothing of use.

Sub Sort_Special()
  With Range("A1").CurrentRegion
    .Replace What:="ANKUR", Replacement:="RAVIANKUR", LookAt:=xlWhole
    .Sort Key1:=.Columns(3), Order1:=xlAscending, Header:=xlYes
    .Replace What:="RAVIANKUR", Replacement:="ANKUR", LookAt:=xlWhole
  End With
End Sub

Also, your thread title mentions cut/paste but your description is about sorting. Very confusing!

 

[JAVEDR]

From your image it looks like Ankur & Ravi entries are in column C not B. Assuming they are in column C, try this (with a copy of your data) but everything is a bit vague.
Your image in post #3 shows us absolutely nothing of use.

Sub Sort_Special()
  With Range("A1").CurrentRegion
    .Replace What:="ANKUR", Replacement:="RAVIANKUR", LookAt:=xlWhole
    .Sort Key1:=.Columns(3), Order1:=xlAscending, Header:=xlYes
    .Replace What:="RAVIANKUR", Replacement:="ANKUR", LookAt:=xlWhole
  End With
End Sub

Also, your thread title mentions cut/paste but your description is about sorting. Very confusing!

Hello peter, Thank you for your feedback with code

Due to data privacy unable to share whole data hence #3 post agree not of use.
You are correct entries are in column C not in B apologies for confusion again.

Please find below exact I'm looking out

Step1. I have data in Column A to D, which I want to sort from A, then B, then C and then D after that suppose

Step2. Column B if Ravi entries are on top that need to be place below Ankur entries. If no entries found then ignore.

Thank you for valuable time on this

 

[Peter_SSs]

Due to data privacy unable to share whole data

Then what about making up some dummy data that is not private but demonstrates the issues you want to deal with and give us that data with an explanation in relation to the dummy data?

 

[JAVEDR]

Then what about making up some dummy data that is not private but demonstrates the issues you want to deal with and give us that data with an explanation in relation to the dummy data?

Book9.xlsx

Have shared actual file on Drive. Thank you once again for making me correct

 

[Peter_SSs]

Your request says

I Want Column B DES To Come Below FOA After Sort Of Column A, B, C & D

However there is not enough information about ..

• What columns are sorted 1st, 2nd, 3rd & 4th
• Whether column B should basically be sorted ascending or descending. For example, why is "Interactive" below "Samlyn Capital"?

 

[JAVEDR]

Your request says

However there is not enough information about ..

• What columns are sorted 1st, 2nd, 3rd & 4th
• Whether column B should basically be sorted ascending or descending. For example, why is "Interactive" below "Samlyn Capital"?

Yes peter,

First sort Column as ascending (atoz) requested Column A, then B, then C & then D
Once sorted **ES to come below *OA

 

[Peter_SSs]

First sort Column as ascending (atoz) requested Column A, then B, then C & then D

If I sort column A ascending, then B ascending then C then D I end up with this.
How can you then just move DES below FOA?
.. and what are you now saying **ES below *OA. Why the change? How does that relate to the sample data?

You also did not address the question of why "Interactive" comes below "Samlyn Capital" if that column is sorted ascending?

EDIT
Data removed at OP's request.