You can populate a dropdown with a list on another sheet by referencing the cells, but the resulting dropdown won’t be dynamic, even when the list is in a table object.

If you’re not working with Table objects, Power Query will prompt you to convert the data range to a Table. Power Query works only with Excel Table objects. In fact, the table names are January ...

Select cells E3:L16. Go to Data, click the dropdown arrow next to What-if Analysis within the Forecast group, and choose Data Table. The Data Table window will open, asking for inputs into Row input ...