Hi Guys, similar help required
I have a dropdown list using data validation to select a year e.g.
Please select a date:
2013/14
2014/15
2015/16 and so on.
Underneath I then have a table which has the same dates going across the row. I would like to auto populate that row depending on what start date was chosen via user input. So in theory:
User selects 2015/16 -----> this then causes the row underneath to auto-populate starting with 2015/16 then 2016/17, 2017/18 etc..
I would bevery greatful for some assistance, please see attached file for template example.
Bookmarks