I have 3 Table , may i know how to combine into 1 table ?
sheet 2013 = year 2013 compare to CY
sheet 2014 = year 2014 compare to CY
sheet 2015 = year 2015 compare to CY
Meaning instead of having 3 sheet , i only wan to have 1 sheet.
So when user
select year = 2013 , it will display 2013 compare with current year.
select year = 2014 , it will display 2014 compare with current year.
select year = 2015 , it will display 2015 compare with current year.
Hope some one can advise me.
As i don't know how to make the second display 2017 YTD sales when user select year =2013.