Record three different macros as you select your range and do the sort.

Then show the forms toolbar.

click on that button icon and draw a button on your worksheet. (repeat twice)

Assign each macro to a different button (and change the caption).

Jimbob wrote:

Please could someone help me to do this. I want to add say three buttons
within a worksheet to click on to sort data in a specific way.

Huge thanks in anticipation

--

Dave Peterson