Instead, you can create a named precedent cell in your backend worksheet. First, select the cell where the calculation value will go, and use the name box in the top-left corner of the Excel ...