I cant figure out a code, to make the rows sort based on the date, given in column B (From B5). Our Company cannot use Automatic macros (Do to Citrix), so would prefer a module that I can connect to an icon or a button click.
The colums from A to V are in use, so the entire row needs to be sorted. Not just the cell contaning the date. Date format: Ex. 22.10.19 would be 22 okt 2019.
The idea is that the user should always use the empty bottom rows, instead of adding new in between to fit the dates. And then it would Automatic sort according to the date.
Hope someone can help solve it.
The colums from A to V are in use, so the entire row needs to be sorted. Not just the cell contaning the date. Date format: Ex. 22.10.19 would be 22 okt 2019.
The idea is that the user should always use the empty bottom rows, instead of adding new in between to fit the dates. And then it would Automatic sort according to the date.
Hope someone can help solve it.
