Re-ordering Array Values

[Walks]

Hi,

I was given an excel sheet that pulls data from historian. It has several rows of device data that is currently ordered by some type of ranking system. I now need to order it by device number (smallest to largest) but whenever I try to do that I get an error saying "You cannot change part of an array".

There are 2 sheets being used. The main sheet contains the actual values in a table that is ordered by the priority of the device the value is assigned too. The second sheet contains the tag names of the data that will be pulled from Historian. The second sheet has all the devices listed in numerical order which is how I want them. I was assuming there might be some VBA code being ran to order the devices and values by a ranking system but I didn't see anything.

I've tried several methods of sorting the items but it won't work.

Workbook_Example1.xlsm
	C	D	E
2	Devices	MAX	Values
3	A-17	1,177	950
4	A-05	1,298	960
5	A-14	1,176	1080
6	A-41	1,148	0
7	A-03	945	150
8	A-02	1,004	700
9	A-44	1,155	710
10	A-65	1,090	900
11	A-71	940	620
12	A-42	1,059	0
13	A-18	1,388	520
14	A-67	1,094	800
15	A-22	1,088	680
16	A-66	904	325
17	A-19	1,289	1175
18	A-37	1,299	75
19	A-12	1,470	Null
20	A-26	1,406	810
21	A-35	1,026	480
22	A-48	1,280	560
23	A-71	1,176	950
Ellen Inj Report

Cell Formulas
Range	Formula
E3:E22	E3	='C:\Program Files (x86)\Common Files\ArchestrA\HistClient.xlam'!wwAnalogLive1("BETA-HIST2", 'Ellen w tags'!$E$3:$E$23,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE)
E23	E23	='C:\Program Files (x86)\Common Files\ArchestrA\HistClient.xlam'!wwAnalogLive1("BETA-HIST2", 'Ellen w tags'!$E$3:$E$23,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE)
Press CTRL+SHIFT+ENTER to enter array formulas.

Workbook_Example1.xlsm
	C	D	E
2	Well	Max Allowable Surface Inj Pressure (PSI)	Current Tbg Pressure (PSI)
3	A-02	1,177	EL_40_I_A_02.Tubing_Pressure
4	A-03	1,298	EL_40_I_A_03.Tubing_Pressure
5	A-05	1,176	EL_40_I_A_05.Tubing_Pressure
6	A-12	1,148	EL_40_I_A_12.Tubing_Pressure
7	A-14	945	EL_40_I_A_14.Tubing_Pressure
8	A-17	1,004	EL_40_I_A_17.Tubing_Pressure
9	A-18	1,155	EL_40_I_A_18.Tubing_Pressure
10	A-19	1,090	EL_40_I_A_19.Tubing_Pressure
11	A-22	940	EL_40_I_A_22.Tubing_Pressure
12	A-26	1,059	EL_40_I_A_26.Tubing_Pressure
13	A-35	1,388	EL_40_I_A_35.Tubing_Pressure
14	A-37	1,094	EL_40_I_A_37.Tubing_Pressure
15	A-41	1,088	EL_40_I_A_41.Tubing_Pressure
16	A-42	904	EL_40_I_A_42.Tubing_Pressure
17	A-44	1,289	EL_40_I_A_44.Tubing_Pressure
18	A-48	1,299	EL_40_I_A_48.Tubing_Pressure
19	A-63	1,470	EL_40_I_A_63.Tubing_Pressure
20	A-65	1,406	EL_40_I_A_65.Tubing_Pressure
21	A-66	1,026	EL_40_I_A_66.Tubing_Pressure
22	A-67	1,280	EL_40_I_A_67.Tubing_Pressure
23	A-71	1,176	EL_40_I_A_71.Tubing_Pressure
Ellen w tags

 

[Walks]

I just noticed that in the first sheet I had already re-ordered the "Max" values to how they should be, you can disregard that column entirely, they are static values. Its the "Values" column I'm trying to figure out. The "Values" column should correspond to the Current Tbg Pressure Column in the second sheet. Some how the values are getting re-arranged. I've tried renaming the devices in numerical order on the first sheet but that didn't work.

Thank you for any help!