Need help with specific macro

  • Thread starter Thread starter Curt St. Romain
  • Start date Start date
C

Curt St. Romain

I am making a scoresheet for a lifting competition. I
need a macro that will sort a specific group of cells in
descending order by the value of cells in a particular
column. I have no idea how to set up this macro. I hope
I have been clear with my request. I know how to sort the
information with my sort command. However, I want this
done hundreds of times in a single day and need it done
with a single key.

Thanks,

Curt
 
Curt,

Record a macro as you select the data and sort it (Tools - Macro - Record).
Or if you wish to do the selection manually, then leave that part out
(select first, then start the macro recorder). If you want to change how it
sorts, the code can be modified. Post the code, and we'll go from there.

You can assign a keyboard shortcut (Ctrl or Ctrl Shift + a key)to your macro
(Tools - Macro - Macros - Select your macro - Options). Or you can use an
OnKey method to allow any key to run it.
 
Back
Top