This is probably a simple task, but I've searched and can't find quite what I'm looking for. I have a spreadsheet with a plant location and several other related columns to that plant. One of the related columns is the "priority" (numerical value 1, 2, 3, etc).

Example cells below:
[Plant 1][Technology][Priority 1]
[Plant 1][Technology][Priority 2]
[Plant 2][Technology][Priority 1]
[Plant 2][Technology][Priority 2]
[Plant 3][Technology][Priority 1]

I would like to create two macros, one to sort by the plant column (alphabetical), and another to sort by the priority column (smallest to largest). I know I can sort this manually, but I need to make this fool proof for less technical people. The entire row for each plant needs to be sorted.

Is this possible? Where do I start?