Excel Data Validation List From Table. Go back to the blank worksheet that we started with before making the administration worksheet select cell a1 on the ribbon select the data tab in the data tools group click on data validation on the settings tab from the allow dropdown list select list in the source textbox type indirect. Click the new button.
From the allow drop down list choose list click in the source box and type an equal sign and the list name for example. Empnames or press the f3 key to see. To start off i ll select the stage column then click the data validation button on the data tab of the ribbon.
You will notice that excel will insert the range reference like.
In the example below the data entry table tbldata is located at j8 m12 and the data validation entry in column j has been set at indirect j 8 and for columns k l and m is has been set as indirect substitute j9. Go to tab formulas on the ribbon. Go back to the blank worksheet that we started with before making the administration worksheet select cell a1 on the ribbon select the data tab in the data tools group click on data validation on the settings tab from the allow dropdown list select list in the source textbox type indirect. Click the new button.
