View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
paulas paulas is offline
external usenet poster
 
Posts: 4
Default Sorting Automatically

I have many worksheets in a shared workbook. My users will input data on any
or all sheets. I would like the sheets to automatically sort (by 3 columns -
Sales Agent; Customer; Invoice#) when they exit the file. I created a macro
to do the sort. So, if I hit CTRL-S it will sort just fine but I'd rather it
be done automatically. Can anyone help me with this?

Thanks!
Paula