Auto Sort When Date Is Entered

**suehatesyou** · 10-22-2010, 07:28 PM

I am looking for a way to auto sort the info in column A based on the numerical account number. The auto sort also should move the rest of the info in the row along with column a.
I want this auto sort to happen once a new entry has been entered with all the information in columns A -L.

Basically the goal is someone with very little knowledge about excel or computers in general can enter information in all 12 columns and then the table will auto sort itself based on the account number.

I believe this has to be done with a macro but i know nothing about them. help please.

**davesexcel** · 10-22-2010, 07:43 PM

Still learning Xl'07, just used the macro recorder to get the sort code then placed it in the worksheet module, right click the sheet tab and select view code, copy and paste this code there.

Please Login or Register  to view this content.

When there is a change in column L the code will run

**suehatesyou** · 10-22-2010, 08:12 PM

Ok it did work. Then i closed it, and now it is not working. The code is still there. but when i enter data in column L nothing happens

**davesexcel** · 10-22-2010, 08:49 PM

You probably need to save it as a macro enabled workbook

**suehatesyou** · 10-22-2010, 08:57 PM

No, it was saved as macro enabled. Well now its working again. Weird. Thanks!

**Lauratb** · 09-05-2013, 11:45 AM

Hi

I am trying to do something similar, although this is my first time with macros. I need the sheet to automatically sort by date once it is entered in the final column. I have conditional formatting throughout the sheet.

I tried using the macro above and amending it to suit (it was effectively a guess) but it did not work.

The example is here... Tenders Due List.xlsm

Any help would be great

**protonLeah** · 09-05-2013, 05:56 PM

Lauratb

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.