VBA Auto Sort The Closing Date Column in multiple worksheets

Could you add a VPA code to my worksheet to automatically sort the closing date in Ascending order 15 seconds after entries are made.
Please set up the code to run on the four worksheets (closing date column only)below.

1st Qtr. Sales
2nd Qtr. Sales
3rd Qtr. Sales
4th Qtr. Sales

Briefly describe to me how to do this in the future.

Thanks,
Chad

Jaslake

People manually enter date, like 1/1/2014.

December 2013 to November 2014, yes.

Thanks,

Jaslake,

The number of rows are fixed at 31.

For the sorting. If its easier to do immediately then lets do it.
I need this code pretty soon.

Thanks,
Chad

jaslake

Code works great.
Could you please add this code to the enclosed spreadsheet.
It has a better format.

Thanks,
Chad

ok how exactly do I do this.

is this a copy and paste in your VBA worksheet to my VBA worksheet?

Thanks for all the time and work you put into this.

Ok I believe I understand now. I was to go to formulas name manager and enter in the ranges from my spreadsheet and then you could enter the final sort code in module 1.


Chad

Jaslake,

One issue, when I save the file and reopen it it gives me an error
excel found unreadable content, if you want to recover unreadable contents of this workbook.

This is what I am getting any idea why this happens?

Removed Records: Sorting from /xl/worksheets/sheet3.xml part

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error074000_01.xml</logFileName>
<summary>Errors were detected in file 'C:\Users\ckcwc744\Dropbox\Excel retail project 1.23.14\Final\Team tracker with financials -chad final2.xlsm'</summary>
- <removedRecords summary="Following is a list of removed records:">
<removedRecord>Removed Records: Sorting from /xl/worksheets/sheet3.xml part</removedRecord>
</removedRecords>
</recoveryLog>

Jaslake

Ok, two questions

1) How would I remove the ascending code from the four quarterly tabs and just put it on the summary quarter tab.

2) I want to transfer closed dates from four quarterly tabs to the summary table a different way

In qtr 1, in the december tab, if I type in 3/1/14 as the closing date I want it to show up in the March table within the summary tab.
This should be set up for all four quarter sheets.

Let me know what you need me to do to assist you in this code.

thanks,
Chad

in the summary table.

Yes. The last filled cell will be the closing date.