Hi, I am creating a database in Excel.
I need to have a dropdown list for each client from 2008 to 2016 in which we add the turnover figures for the year.
I have created my drop down menu but it selects one year only, first of all, then secondly, it does not give you the option to add a figure. Ideally I want to:
1. Select the year starting at 2008
2. Once the year appears, enter a figure for that year
3. Be able to select any one of the years and it should give me the figures I have captured for that particular year.
Regards,
Bookmarks