how do i lock a sort, ie no header row

  • Thread starter Thread starter sotydor
  • Start date Start date
S

sotydor

I want to sort by no header row, colum M, the colum N, then colum O.
I do not want to have to insert this data everytime I sort. How can I
preserve the order of this sort?
 
hi
record a macro. Tools>macro>record new macro....
give the macro a name. do your sort. the macro will remember.
you can assign the macro to a toolbar icon, a sheet command button or select
from the menu i.e. tools>macro>macros>select macro>run

regards
FSt1
 
Back
Top