J
Jacques Brun
Try the following
Your are prompted for a macro name and associated key
stroke.
Then perform your sort. The commands will be recorded in
the macro. At the end click on the "Stop Recording button"
By entering the selected key strocke your sort will be
automatically executed.
Tools >Macros >Record New Macro
Your are prompted for a macro name and associated key
stroke.
Then perform your sort. The commands will be recorded in
the macro. At the end click on the "Stop Recording button"
By entering the selected key strocke your sort will be
automatically executed.
clicking data | sort everytime?-----Original Message-----
I have an excel 2003 worksheet
I repeatedly do the same 3 way data sort of the same 5 of 6 columns.
Can I set this sort up as a key stroke rather than