How Can I Sort the Dates Automatically Not Messing Up The Format

[Ratan868]

A Screenshot of the worksheet is attached below. Help needed please as I'm new to using codes in VBA.

https://1drv.ms/u/s!AuJosJM5re-thDoADN_0odaoTIQH

 

[Joe4]

Welcome to the Board!

Many of us ae unable (or unwilling) to download files, due to security protocols (my company actually blocks all file and image hosting sites).

You may get more help if you are able to post your image here. There are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html. Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.

 

[Ratan868]

Thank you for the information. Will amend to suit.

 

[Ratan868]

[TABLE]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH][/TH]
[TH]C[/TH]
[TH]D[/TH]
[TH]E[/TH]
[TH]F[/TH]
[TH]G[/TH]
[TH]H[/TH]
[TH]I[/TH]
[TH]J[/TH]
[TH]K[/TH]
[TH]L[/TH]
[TH]M[/TH]
[TH]N[/TH]
[TH]O[/TH]
[TH]P[/TH]
[TH]Q[/TH]
[/TR]
</thead><tbody>[TR]
[TD="align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=404040]#404040[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=404040]#404040[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=404040]#404040[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=404040]#404040[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=404040]#404040[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=404040]#404040[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=404040]#404040[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=404040]#404040[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=404040]#404040[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=404040]#404040[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=404040]#404040[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=404040]#404040[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=404040]#404040[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=404040]#404040[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=404040]#404040[/URL] , align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6699CC]#6699CC[/URL] , align: center"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6699CC]#6699CC[/URL] , align: center"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6699CC]#6699CC[/URL] , align: center"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6699CC]#6699CC[/URL] , align: center"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6699CC]#6699CC[/URL] , align: center"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6699CC]#6699CC[/URL] , align: center"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6699CC]#6699CC[/URL] , align: center"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6699CC]#6699CC[/URL] , align: center"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6699CC]#6699CC[/URL] , align: center"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6699CC]#6699CC[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6699CC]#6699CC[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6699CC]#6699CC[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6699CC]#6699CC[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6699CC]#6699CC[/URL] , align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6699CC]#6699CC[/URL] , align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6699CC]#6699CC[/URL] "]Guest name[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6699CC]#6699CC[/URL] "]Check in[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6699CC]#6699CC[/URL] "]Check-out[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6699CC]#6699CC[/URL] "]Status[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6699CC]#6699CC[/URL] "]Comments[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6699CC]#6699CC[/URL] "]Daily[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6699CC]#6699CC[/URL] "]Adults[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6699CC]#6699CC[/URL] "]Children[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6699CC]#6699CC[/URL] "]Bedroom[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6699CC]#6699CC[/URL] "]Type[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6699CC]#6699CC[/URL] "]Total Daily[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6699CC]#6699CC[/URL] "]Downpayment[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6699CC]#6699CC[/URL] "]Discount[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6699CC]#6699CC[/URL] "]Additional Charges[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6699CC]#6699CC[/URL] "]Balance[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD]Taylor Smith[/TD]
[TD]27/10/2018[/TD]
[TD]29/10/2018[/TD]
[TD]CHECKED IN[/TD]
[TD][/TD]
[TD="bgcolor: #F2F2F2"]2[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]SDR 6[/TD]
[TD="bgcolor: #F2F2F2"]SINGLE[/TD]
[TD="bgcolor: #F2F2F2"]$700.00[/TD]
[TD][/TD]
[TD]$250.00[/TD]
[TD][/TD]
[TD="bgcolor: #F2F2F2"]$450.00[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD]Creed Nelson[/TD]
[TD]23/10/2018[/TD]
[TD]25/10/2018[/TD]
[TD]CHECKED IN[/TD]
[TD][/TD]
[TD="bgcolor: #F2F2F2"]2[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]MR 8[/TD]
[TD="bgcolor: #F2F2F2"]DOUBLE[/TD]
[TD="bgcolor: #F2F2F2"]$900.00[/TD]
[TD][/TD]
[TD]$150.00[/TD]
[TD][/TD]
[TD="bgcolor: #F2F2F2"]$750.00[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD]Greta Vincent[/TD]
[TD]11/11/2018[/TD]
[TD]14/11/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #F2F2F2"]3[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]MR 7[/TD]
[TD="bgcolor: #F2F2F2"]TRIPLE[/TD]
[TD="bgcolor: #F2F2F2"]$1,950.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #F2F2F2"]$1,950.00[/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD]Vashnu St Paul[/TD]
[TD]01/01/2019[/TD]
[TD]05/01/2019[/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #F2F2F2"]4[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]MR 1[/TD]
[TD="bgcolor: #F2F2F2"]SINGLE[/TD]
[TD="bgcolor: #F2F2F2"]$1,400.00[/TD]
[TD]$1,050.00[/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #F2F2F2"]$350.00[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD]Alison Crooks[/TD]
[TD]05/11/2018[/TD]
[TD]06/11/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #F2F2F2"]1[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]MR 4[/TD]
[TD="bgcolor: #F2F2F2"]SINGLE[/TD]
[TD="bgcolor: #F2F2F2"]$350.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #F2F2F2"]$350.00[/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #F2F2F2"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #F2F2F2"][/TD]
[TD="bgcolor: #F2F2F2"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: #F2F2F2"][/TD]
[/TR]
</tbody>[/TABLE]
[CENTER][COLOR=#161120][B]RES[/B][/COLOR][/CENTER]

[TABLE="width: 85%"]
<tbody>[TR]
[TD][B]Worksheet Formulas[/B][TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L6[/TH]
[TD]=IF([COLOR=Blue]K6="","",IF([COLOR=Red]VLOOKUP([COLOR=Green]K6,CAD_Q!$C$6:$D$105,2,FALSE[/COLOR])=0,"",VLOOKUP([COLOR=Green]K6,CAD_Q!$C$6:$D$105,2,FALSE[/COLOR])[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M6[/TH]
[TD]=IFERROR([COLOR=Blue]VLOOKUP([COLOR=Red]K6,CAD_Q!$C$6:$E$109,3,FALSE[/COLOR])*H6,""[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L7[/TH]
[TD]=IF([COLOR=Blue]K7="","",IF([COLOR=Red]VLOOKUP([COLOR=Green]K7,CAD_Q!$C$6:$D$105,2,FALSE[/COLOR])=0,"",VLOOKUP([COLOR=Green]K7,CAD_Q!$C$6:$D$105,2,FALSE[/COLOR])[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M7[/TH]
[TD]=IFERROR([COLOR=Blue]VLOOKUP([COLOR=Red]K7,CAD_Q!$C$6:$E$109,3,FALSE[/COLOR])*H7,""[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L8[/TH]
[TD]=IF([COLOR=Blue]K8="","",IF([COLOR=Red]VLOOKUP([COLOR=Green]K8,CAD_Q!$C$6:$D$105,2,FALSE[/COLOR])=0,"",VLOOKUP([COLOR=Green]K8,CAD_Q!$C$6:$D$105,2,FALSE[/COLOR])[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M8[/TH]
[TD]=IFERROR([COLOR=Blue]VLOOKUP([COLOR=Red]K8,CAD_Q!$C$6:$E$109,3,FALSE[/COLOR])*H8,""[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L9[/TH]
[TD]=IF([COLOR=Blue]K9="","",IF([COLOR=Red]VLOOKUP([COLOR=Green]K9,CAD_Q!$C$6:$D$105,2,FALSE[/COLOR])=0,"",VLOOKUP([COLOR=Green]K9,CAD_Q!$C$6:$D$105,2,FALSE[/COLOR])[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M9[/TH]
[TD]=IFERROR([COLOR=Blue]VLOOKUP([COLOR=Red]K9,CAD_Q!$C$6:$E$109,3,FALSE[/COLOR])*H9,""[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L10[/TH]
[TD]=IF([COLOR=Blue]K10="","",IF([COLOR=Red]VLOOKUP([COLOR=Green]K10,CAD_Q!$C$6:$D$105,2,FALSE[/COLOR])=0,"",VLOOKUP([COLOR=Green]K10,CAD_Q!$C$6:$D$105,2,FALSE[/COLOR])[/COLOR])[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M10[/TH]
[TD]=IFERROR([COLOR=Blue]VLOOKUP([COLOR=Red]K10,CAD_Q!$C$6:$E$109,3,FALSE[/COLOR])*H10,""[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H6[/TH]
[TD]=IF([COLOR=Blue]OR([COLOR=Red]D6="",E6=""[/COLOR]),"",E6-D6[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H7[/TH]
[TD]=IF([COLOR=Blue]OR([COLOR=Red]D7="",E7=""[/COLOR]),"",E7-D7[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H8[/TH]
[TD]=IF([COLOR=Blue]OR([COLOR=Red]D8="",E8=""[/COLOR]),"",E8-D8[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H9[/TH]
[TD]=IF([COLOR=Blue]OR([COLOR=Red]D9="",E9=""[/COLOR]),"",E9-D9[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H10[/TH]
[TD]=IF([COLOR=Blue]OR([COLOR=Red]D10="",E10=""[/COLOR]),"",E10-D10[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]Q6[/TH]
[TD]=IFERROR([COLOR=Blue]M6-N6-O6+P6,""[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]Q7[/TH]
[TD]=IFERROR([COLOR=Blue]M7-N7-O7+P7,""[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]Q8[/TH]
[TD]=IFERROR([COLOR=Blue]M8-N8-O8+P8,""[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]Q9[/TH]
[TD]=IFERROR([COLOR=Blue]M9-N9-O9+P9,""[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]Q10[/TH]
[TD]=IFERROR([COLOR=Blue]M10-N10-O10+P10,""[/COLOR])[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

So, do you always have a header row in row 5, and the data below it?
What columns do you want it sorted by?
What do you want to trigger this "automatic" sort (when should it run)?

 

[Ratan868]

H Joe4,
Those are subheadings in row 5. Above them are main headings which were not highlighted.

I would like to sort column's D and E ( the Dates), so that it shows the dates in order of day, month and year.

I would like for this to be done automatically, so if new names and dates are added to the sheet, it would automatically sort by dates.

Regards,
Ratan

 

[Joe4]

I assume that you want to sort all related columns (C-Q) along with the dates in columns D and E, right?
Also, the issue still arises as to when the automatic sort should run. Ideally, you do not want it to sort until all the proper columns have been updated for a row. Otherwise, things will start moving around when you are trying to enter them (as soon as you finish one column), the data would sort.

So we need to come up with a "hard-and-fast" rule as to when this sort should happen.
Should it wait until columns C, D and E are all populated?

An alternative would be NOT to have anyone enter data directly into the sheet itself, but rather create an entry form, where they populate all the necessary fields, and click a Submit button. Then the VBA code behind it could paste the data in and sort it all at the same time upon click of the Submit button.

 

[Ratan868]

I totally understand you. Ideally would like for it to sort when all the data from column's C to Q are populated. If not then until C, D and E are all populated.

For the alternative, do you think that might be easier, if not we could stick with the first solution.

Regards,
Ratan

 

[Joe4]

Ideally would like for it to sort when all the data from column's C to Q are populated.

I don't think that would work for you. In looking at your data example, you do not have a single row of data where all these columns are populated. Not a single row has column G populated, and there are also blanks in columns F, N, O, and P.

An entry form would really be useful here. However, if you are an experienced in creating forms using VBA, then this would not be an easy task for you.

Other alternatives:
- Have a data entry section at the top of your page, where you ask them to enter in details for a new row, and click a submit button, which would then have VBA code paste the data into your table and sort your data, and also clear the entry section (sort of like an entry form without the form).
- Create a sort macro that just runs whenever you click it (so it would be run manually instead of automatically). So you would just click the button whenever you want (i.e. after entering a new record)

 

[Ratan868]

I agree that it would not work from C to Q. It would be just as perfect if the dates can be sorted after the data in C, D and E are populated.

If not, regarding the alternative you can show me an example and I would pattern it.

Regards,
Ratan