Very good explanation, Jerry - it must have taken you ages to type all
that. Well done !

Pete

On May 18, 11:08 pm, JLatham <HelpFrom @ Jlathamsite.com.(removethis)
wrote:
OOPS! I forgot to add the 'make it smart' code into the How It Should Look
example toward the end, but I think you probably realize that.



"Kim T" wrote:
I want the spread sheet to sort automatically by date after I'm finished
entering data. Can I set up a macro if so what do I do? If not how can I make
my data sort by date automatically when I save or close out excel?- Hide quoted text -

- Show quoted text -