T
tahamed
I have columns B6 to F6, where users will enter dates in mm/dd/yyyy
format. Cells could be empty. Column A6 will contain names. I want to
do an automatic update of the list as the user will insert/update
dates. The sort order is needed to be in an Ascending order by dates.
To do this the routine has to find the smallest date in each row, and
then order the rows according to these smallest dates (smallest of
these found dates first). If in any row there is no date, then this row
will come first. Pls. help.
format. Cells could be empty. Column A6 will contain names. I want to
do an automatic update of the list as the user will insert/update
dates. The sort order is needed to be in an Ascending order by dates.
To do this the routine has to find the smallest date in each row, and
then order the rows according to these smallest dates (smallest of
these found dates first). If in any row there is no date, then this row
will come first. Pls. help.