Adding "button" to click to sort updated data?

  • Thread starter Thread starter FISH
  • Start date Start date
F

FISH

I'm using Excel 2003 and need to add a button that users can click to sort
new data. Once a row has been updated with new data, I want the users to
simply be able to click this "button" in order to sort the new data in
descending order.


I have several different sets of data that I want to add these "buttons" to.
One for example is found between rows R5-R16. I have results from each row's
data in column R. I then users to be able to simply click this new "button"
to sort those results.

How can I do this?

Thanks in advance for any help !!!
 
Turn on the Macro Recorder and manually do a sort the way you want the
button click to. Stop recording and assign that macro to the button. You
may want to rename it to something more meaning full than Macro1()

HTH
Regards,
Howard
 
Thanks, but how do I assign the macro to the button?

I assume I add a command button and then assign this newly recorded macro to
it, but not sure how to do that?


Is there also a way to simply assign this newly recorded macro to a specific
cell instead of a button? I would actually prefer to just add this macro to
a cell for users to click on. That way I wouldn't have to create the buttons
one by one and make sure they fit exactly in the cell, look the right way,
etc...(I'm new to all this really).


Thanks again for the help.
 
I'd use a button from the Forms Tool bar. Right click on the main tool bar
and check Forms. There is a button icon which you click on and move the
cursor to the worksheet and left click and hold as you drag to the right and
down. Release once you get to the size you like.

You can make your button and in the process it will give you an option to
Record Macro and it will be assigned to the button. Or you can right click
on a finished button and select Assign Macro.

Also once you have a button made you can right click on it and Copy. Select
a cell where you want a button, right click and then Paste. Select another
cell, right click again and Paste. And right click the buttons to Edit etc.

Roger's suggestion may be a bit confusing for a beginner. Once you've made
a few buttons it really is pretty easy.

HTH
Regards,
Howard
 
Thanks for the help so far.

I was able to do what you suggested, but ran into a problem with the macro
when things change in my spreadsheet.

I simply recorded the new macro and assigned it to the button as you
suggested, but it gets all messed up when I have to add rows or delete rows
within the section the macro is sorting.

For example:
One of the buttons with a macro assigned to it was set to sort column R from
rows 6-23 and works well as the spreadsheet is now. But, if I delete rows
8,9 and 10 and click the button the macro is assigned to, things get all
messed up. It appears to still sort rows 6-23 even though some of the rows
have been deleted...so now that I have deleted 3 rows, Excel is now sorting
3 more rows (the rows that were 24,25,and 26).
 
I see what you are up against. Probably have to set a range and then sort
the range, which is into vb code. You probably don't want or don't know how
to do that and I would have trouble telling you via e-mails.

I will be glad to look at a example workbook and try for a solution if you
want. Include your data layout and exactly what you want to happen and
where you want it to happen.

Regards,
Howard
(e-mail address removed)
 
Back
Top