Hey guys,
I have a function in column A that works as a dropdownbox to give priorities: high - medium - low.
I want to be able to sort the rows data so high is on top and low is at bottom.
A=priority B=data1 C=data2 D=data3 E=data4 F=data5
If A1 priority changes, B1 C1 D1 E1 F1 should ascend/descend to the same row as A1 does, this needs to happen with every row on the sheet.
aandachtspunten.xlsx
Problem solved.
Would be great if any adjustments made on priorities would instantly sort the cells instead of pressing sort to refresh each time, but it works!
ps. sorry for posting on the wrong sub forum.
Bookmarks