Hi guys,
I have a simple problem, or at least i believe its simple.
I have a spreadsheet that helps me to tracks orders. I want to be able to add a bit code to my current VBA script that sorts the data based on the values in a particular column (smallest to largest).
Current table looks like this:
<tbody>
</tbody>
I want to add be able to sort the data, smallest to largest based on Column E (tittle Priority)
Any help would be appreciated.
Thanks
I have a simple problem, or at least i believe its simple.
I have a spreadsheet that helps me to tracks orders. I want to be able to add a bit code to my current VBA script that sorts the data based on the values in a particular column (smallest to largest).
Current table looks like this:
Order Number | Date | Quantity | Colour | Priority |
548562 | 12-09-2012 | 56 | VBA formula | 2 |
325415 | 01-04-2012 | 102 | VBA formula | 1 |
012103 | 06-10-2012 | 12 | VBA formula | 2 |
025486 | 26-08-2012 | 2 | VBA formula | 3 |
520148 | 01-01-2012 | 54 | VBA formula | 4 |
<tbody>
</tbody>
I want to add be able to sort the data, smallest to largest based on Column E (tittle Priority)
Any help would be appreciated.
Thanks