Pretty straight forward question!
I have a relatively complex spreadsheet that uses "Names" rather than actual values.
Example: Cell A25 might have a name "SalesYearToDate"
There are literally hundreds of "names" which have a standardized naming structure.
Question: I want to do a global replace of many of my names. So for instances I want to change "SalesYearToDate" to "PurchasesYearToDate" and also "SalesTargets" to "PurchaseTargets" etc (100 times)
(I am familiar with VBA , not an expert though).