I have received an Excel workbook that contains dozens of worksheet tabs, including thousands of formulas. Sheet1 is the 'master' price list, with hundreds of items, along with the corresponding cost of each item. Sheet2, Sheet3 (and so on) contain formulas which reference back to the prices in Sheet1. However, the creator of this workbook did not use named ranges, and I need to name the individual cells (in Sheet1) which contain the prices. I have named the cells in Sheet1, using the 'Workbook' scope, but am unsuccessful at applying the names to other sheets.
Define Name > Apply Names > OK, pops up a window saying "Microsoft Excel cannot find any references to replace". How can I apply names to an existing formula in a different worksheet tab?
Thanks for your expertise,
pinebush