Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jimbob
 
Posts: n/a
Default Adding buttons in a sheet to sort data

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
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort data from 1 work sheet into another andrewgwatson Excel Worksheet Functions 0 June 1st 05 03:10 AM
adding data from one sheet to another sheet as a dropdown list bo. gatorguy Excel Discussion (Misc queries) 1 February 18th 05 10:51 PM
Data > Sort function amnesia? Dave D Excel Discussion (Misc queries) 1 November 29th 04 10:44 PM
getting data from 2 different exc sheet pinar Excel Worksheet Functions 1 November 9th 04 02:58 PM
Naming & renaming a sheet tab Cgbilliar Excel Worksheet Functions 1 November 7th 04 05:57 PM


All times are GMT +1. The time now is 07:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"