Question: how to copy total from one sheet to another in excel?
Answer: Click the cell where you want the total to appear. Type "=" without quotes (here and throughout) to alert Excel that you are entering a formula. Click the bottom sheet tab and select the cell that contains the original total. Press "Enter" to accept the reference and mirror the total.