Excel Auto Generated Data Entry Form Shortcomings and Request

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 Exc...