Forum Discussion
i am trying to add a column of date cells that have a drop down date rather than type it in every ti
hynguyen thank you for your input what im trying to do is build a log book.. each movement which requires to be logged happens on different dates so what im trying to create is a drop down date picker or similar at the beginning of every row of the log entry. i have managed to semi automate other entries with drop down list so that the time filling out the log book is kept to a minimum regarding typing in. ie places, times etc etc.
robinflyer sorry I do not really get what you want to achieve. If you can show a sample of your desired output and available inputs with clearer explanations, it would be easier to suggest a solution. However, it seems that a macro would work more efficiently in your example.
hynguyen the first column is a date column and rather than type in the date every time i would like to be able to use a drop down date picker of sorts. every other cell is created from a drop down list, the only manual input is the times and everything else in the workbook self populates from that
robinflyer The solution I suggested earlier works just fine for your purpose. Please see the attached sample workbook. You can drag cell A2 down or copy paste it over to any place in the same workbook and you will have a date dropdown in-cell. If you want to change the range of available dates (currently I choose the whole year 2020), just type the desired earliest date of your range into cell A2 of Tab Help instead and if you need more than 1 year of dates, drag cell A367 of Tab Help down as you wish.
However, note that dropdown list in Excel would be most efficient if your range of selection is not too long, otherwise the time you spend scrolling down to find the date to input may be longer than manually type it in. An alternative is to add to your cell a calendar dropdown/popup instead but it would either require a macro or a Date and Time picker control which is not very easy to install (you can refer to https://www.ablebits.com/office-addins-blog/2016/10/12/insert-calendar-excel-datepicker-template/). You can also consult an add-in for Date picker at https://www.rondebruin.nl/win/addins/datepicker.htm.