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

Ratan868

New Member
Joined
Oct 19, 2018
Messages
9
A Screenshot of the worksheet is attached below. Help needed please as I'm new to using codes in VBA.
s!AuJosJM5re-thDoADN_0odaoTIQH


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

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
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.
 
Upvote 0
[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]

 
Upvote 0
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)?
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0
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)
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,549
Messages
6,114,264
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top