I have created table1 on tab Empl By Dept with headers for Employee, supervisor and dept.  I am using a drop down list on another tab of the same workbook to select data from this table. Per excel help when choosing my source for this drop down  it should put the table name references when I click on the  cell below the header name employee.  instead it puts the cell reference names ie…a2.  I have tried several variations shown in help trying to get the syntax right to pull this data.  I am wanting the drop down choices to automatically change if the table info changes.  Using table references is supposed to do this.  help….

​I have created table1 on tab Empl By Dept with headers for Employee, supervisor and dept.  I am using a drop down list on another tab of the same workbook to select data from this table. Per excel help when choosing my source for this drop down  it should put the table name references when I click on the  cell below the header name employee.  instead it puts the cell reference names ie…a2.  I have tried several variations shown in help trying to get the syntax right to pull this data.  I am wanting the drop down choices to automatically change if the table info changes.  Using table references is supposed to do this.  help….  Read More

​