Sorting all data based on data in single column (DATES)

Have this excel sheet and I need to sort all columns based of on data in Column H
• Column H are dates
• Ask the user to select the range
• Once selected, sort all data based on the values in column H in newest to oldest

I tried the following :

Please Login or Register  to view this content.

Problem I encountered:

• Unable to select all the rows and columns – I think I am unable to tell it which is the LAST ROW that needs to be selected

Another thing I tried doing is:

• Record the macro and go to DATA>Sort and select the columns and sort them from newest to oldest.

This gives the output but :
• It sorts row 1 too
• The selection has to be a user input using input box

FILE ATTACHED:

Thanks,





xlmxm.xlsm