VBA to sort specific range

[Russk68]

Hi All

I would like to columns A3:I40 with a Deactivate event. Column A is a number column and is what I need to sort by.


I have 3 columns with formulas that need to stay intact.
Col D:=IFERROR(INDEX('Fixture Specs'!$A$2:$A$4000,MATCH(B3,'Fixture Specs'!$B$2:$B$4000,0)),"")
Col F:=COUNTIFS(PBU_ColK,B3,PBU_ColL,"=Assigned To Channel")
Col G:=COUNTIFS('Patch By UNIVERSE'!$U$3:$U$2199,B3,'Patch By UNIVERSE'!$W$3:$W$2199,"=TBD")

Thank you!

Russ

 

[Joe4]

I don't think your question is quite clear.
Can you post a sample of your data, and then post what you would like the expected output to look like?

 

[Russk68]

Hi Joe
I see your point. I try hard to make myself clear but I missed this one. I haved it worked out but thank you for your input!