I have some holiday list in different column in sheet 1 and make name range YR_2017 for A column, YR_2016 for B column and so on upto for D column like below:-
A B C D
1 YR_2017 YR_2016 YR_2015 YR_2014
2 12/01/2017 11/08/2016 06/12/2015 16/03/2014


3 01/04/2017 12/11/2016 03/10/2015 14/02/2014
4 23/08/2017 23/01/2016 14/02/2015 15/03/2014
5 26/07/2017 26/07/2016 15/07/2015 18/04/2014
6 01/02/2017 13/04/2016 01/06/2015 01/11/2014
7 24/09/2017 23/08/2016 09/08/2015 09/04/2014
8 12/10/2017 24/10/2016 18/07/2015 29/07/2014
9 13/12/2017 25/03/2016 15/05/2015 15/08/2014
10 14/11/2017 14/04/2016 25/03/2015 23/06/2014

In cell A2 of Sheet 2, I have used a formula ="YR_"&A1 and A1 type any year from the above column.

Now I want, if I change the year in A1 of Sheet 2 then the date list of the year should be show in ascending order from A3 to a10 or upto last date of the year list.

Help me if there is any formula without macro

Thank in advance

Take a look at the attached.

Attached Files

AutoSort.xlsx (10.8 KB, 63 views)

thanks, it working properly and by that I have solve my a big problem