View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dd dd is offline
external usenet poster
 
Posts: 12
Default Using Macro to sort without clicking on macro button

Hi,
I have four columns of data. I want to sort Col C in ascending order,
then Col A in ascending order. When someone enters a name in Col C,
they would have to click on the macro button to resort the data. So
instead of clicking on the macro button, is there a way to
automatically resort the data after it is entered in Col C or Col A.
Thanks for your help.