This formula subtracts the number in workbook 2 from the number in workbook 1. Replace the workbook title, sheet name and cell to match the information you previously wrote down.

It is possible to modify Excel’s default blank workbook; you can even modify the default new worksheets that you insert into your existing workbooks.

You don’t need to manually re-enter Excel spreadsheet data in another workbook. Learn how to copy a worksheet to another workbook here.