How to link Excel data table to input cells on multiple or different worksheets?

A data table will work even if it is on a separate worksheet as the input cells. If you want a step by step solution, skip to the section below. You can download an example in Excel here: http://excelhelphq.com/wp-content/uploads/2014/08/Datatable-Example.xlsx Our sponsors: Strategy The strategy is to have your original excel sheet’s input cells to change only…