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: https://excelhelphq.com/wp-content/uploads/2014/08/Datatable-Example.xlsx Strategy The strategy is to have your original excel sheet’s input cells to change only when the…