macro sequence order

[kelvin_9]

HI, I use below code to run my worksheet but I am wondering if this can be run with a special sequence order?
I have my crew schedule by scheduler, but usually mess with name sequence.
how can i work with my request with my code here, Brenda first and then, Luna, Zoe, Debby, Elaine, Ling, Mei, Shera
(ps. if i can set another pattern anytime without messy again, that will be great!!! example: Brenda, Debby, Elaine, Ling, Luna, Mei, Shera, Zoe)

let me know if you need my workbook for easy reference

THANK YOU SO MUCH FOR YOUR KIND HELP

Book1
	A			D				H
49	WEEK 6			8/11/2020				9/11/2020
50	11/8/2020 - MS-Full Time			SCHEDULE				SCHEDULE
51	Elaine			09:45 - 19:15				09:45 - 19:15
52	Ling			10:30 - 20:00				10:45 - 20:15
53	Mei			10:30 - 20:00				10:30 - 20:00
54	Shera			12:00 - 21:30				10:30 - 20:00
55	Debby			Vacation Leave Day 1.0				Vacation Leave Day 1.0
56	Zoe			09:15 - 18:45				09:15 - 18:45
57	Luna			09:15 - 18:45				09:15 - 18:45
58	Brenda			12:00 - 21:30				11:30 - 21:00
RESULT

Cell Formulas
Range	Formula
D49	D49	=IFERROR((VLOOKUP($A49,CALENDAR!$A:$H,2,FALSE)),"")
H49	H49	=IFERROR((VLOOKUP($A49,CALENDAR!$A:$H,3,FALSE)),"")
D51:D58	D51	=IF(OR(C51="*",C51=""),IF(ISNUMBER(MATCH(D$49,INDEX(RDO!$A$2:$M$100,,MATCH(RESULT!$B51,RDO!$A$1:$M$1,0)),0)),"RDO",""),IF(ISNUMBER(MATCH(D$49,INDEX(RDO!$A$2:$M$100,,MATCH(RESULT!$B51,RDO!$A$1:$M$1,0)),0)),"SHOULD BE RDO",IF(C51="00:00 - 00:00",VLOOKUP($A51,LASTWEEK!$A:$I,3,FALSE),C51)))
H51:H58	H51	=IF(OR(G51="*",G51=""),IF(ISNUMBER(MATCH(H$49,INDEX(RDO!$A$2:$M$100,,MATCH(RESULT!$B51,RDO!$A$1:$M$1,0)),0)),"RDO",""),IF(ISNUMBER(MATCH(H$49,INDEX(RDO!$A$2:$M$100,,MATCH(RESULT!$B51,RDO!$A$1:$M$1,0)),0)),"SHOULD BE RDO",IF(G51="00:00 - 00:00",VLOOKUP($A51,LASTWEEK!$A:$I,4,FALSE),G51)))

 

[Dossfm0q]

is this linked with other source

 

[kelvin_9]

yes, i have a schedule draft from scheduler
and then i use macro(formula)to run like this
but i cant set the sequence like i said

do you need my workbook?

thanks so much for answering

 

[Dossfm0q]

may be

 

[kelvin_9]

i have send you the file link, please check

thank you for answering