for your detailed steps with screenshots, you should see How to replace formulation with their values in Excel.
You can't make named ranges in Excel for the net, but You need to use the named ranges that you simply https://luclkia961374.bloggactivo.com/27999675/5-essential-elements-for-sample-excel