Web everything until now works great now with all that information i would like to add the when i choose a name on the drop down menu on page pag1 also on that.

How to add options in drop down list in excel. Click data validation under the data tools section of the data tab. Web to add an item, go to the last row in the column, press enter or return, enter the new list item, and press enter or return again. Web i have a table that contains staff names and days of month.

Enter a name, for example choices, and press enter. =unique (a2:a21) optionally, you can sort. Choose the settings tab in the.

Select data validation to open the data validation dialog box. To extract the unique items, use this formula: Then, go to the data tab and click “data validation” in the data tools section of the ribbon.

Select cell b3 to make it the active cell. This will select the cell. Select this range, then click in the name box on the left hand side of the formula bar.

Web select the cell where you want the list. In the source box, enter the formula that indirectly refers to table1's column named items. Let's say that the cell.

Web you aim to add a dropdown list where each item appears just once.