Hello, I am In a bind.

Process: Import new data from .CSV file.
Data is 6000 + rows. Same # of columns.
Sort "Status" to only have PASS.
Sort "Part Number"
Lastly... Average Each "Part Number" values in "Sheet2"


Only need values from certain Columns. They Are Columns;
C,F,G,H,L,M,N,O,P,Q,R,S,T,U,V,W = 16 COLUMNS Total.

I have it set to if you click on "PartNumber" or "Status", They sort accordingly to the enabled Macro.
New Data.xlsm
Let me know if there is anything I can clear up?