Excel has this incredible feature for auto generating a data entry form based on a selected table.
In my table, certain columns, under data validation have drop down lists created. However, when Excel generates the data entry form, the entry form does not pick up on the drop down lists for assigned cells.
As the way the data entry form is today, it cannot be used for data entry since it does not pick up or display the drop down list for a given data entry field.
Would like to suggest this feature of the data entry form to include drop down lists if a drop down list has been created for certain cells in a table.
Thanks.
