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
robinflyer Not quite sure if I understand your request correctly but you can do the following:
1. In a separate section in your workbook (usually I have a Help Tab to keep all types of these information that would be used in other Tabs), create a list of dates that you want to be included in the dropdown with the heading "DATE SELECTION". Select both the heading and the rows containing dates and CTRL-T to convert into a table (remember to choose My Table has heading). Rename that table to Date_Selection (select any cell in that Table/go to Design Tab/at the left corner there is a field Table Name and you replace the current name Table n with your name)
2. In the cell where you want to have the date dropdown (it could be anywhere, any Tab in your workbook), select the cell/Data/Data Validation/ choose List and in the field where the source list is required, type = INDIRECT("Data_Selection[DATE SELECTION]")
3. Once the drop down is shown properly, copy that cell and paste over any where you want to have the date drop down shows (or drag that cell down iif same column)
Because the Date_Selection is a table in your workbook, you can refer to it from anywhere within the workbook and do not need to have it on each Tab you want to show the dropdown.
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
