ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   updating formulas with named cell references in a different worksh (https://www.excelbanter.com/excel-worksheet-functions/143508-updating-formulas-named-cell-references-different-worksh.html)

sjSQW

updating formulas with named cell references in a different worksh
 
I would like to use the named cell references feature of Excel to make my
formulas easier to understand. I know how to update formulas when the named
cell is in the same worksheet, but when I try to apply the cell references
when the formula is in a different worksheet to the formula, it does not
work. Can you help?


All times are GMT +1. The time now is 03:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com