code for sort my database

[santosh226001]

hello
we enclosed here my sample data file

we want to sort data on Colum D (Cat & No) with following order
SH MDR ODR VR

currently when we sort data with sort command then data sort this order
MDR odr sh Vr

pls suggest me vba code

thank you so much

[tehneXus]

try this on that sheet:

Please Login or Register  to view this content.

[santosh226001]

hi tehneXus

Actually ur currently code not sorting data as per my order
my order is following

SH.. MDR.. ODR....VR

currently ur macro sort this order
mdr oDR SH VR

thanks for responce

[tehneXus]

Ah sorry, copied the wrong line from your post. You can just change the order of in the array in 3 lines of the code, e.g.

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.