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
https://1drv.ms/u/s!AuJosJM5re-thDoADN_0odaoTIQH
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How Can I Sort the Dates Automatically Not Messing Up The Format
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 74,123
- Office Version
- 365
- Platform
- Windows
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.
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]
<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
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
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
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 74,123
- Office Version
- 365
- Platform
- Windows
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.
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
For the alternative, do you think that might be easier, if not we could stick with the first solution.
Regards,
Ratan
Upvote
0
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 74,123
- Office Version
- 365
- Platform
- Windows
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
If not, regarding the alternative you can show me an example and I would pattern it.
Regards,
Ratan
Upvote
0
Similar threads
- Solved
