Is it possible to create some VBA to replace one part of an array formula? I'm concerned because of the whole shift-cntrl-enter thing.
Current formula(s) - actually about 20 versions of this exact formula with a different cell reference other than K13
{=SUM(IF((allbudgetentered[Goal]=K13),IF(allbudgetentered[Funding Source]="TARDIS",allbudgetentered[Amount],0)))}
The only change I need to make is to the "TARDIS" part (I made it silly and Whovian just for fun while tweaking...but obviously it needs to read the appropriate funding source now - BORING!)
Since I have several other changes that I need to make on several dozen spreadsheets, I'd like to add it to the other coding I have and just do the fixes all at once.
So how can I replace every instance of "TARDIS" with something boring and adult like "Internal Revenue" or "Donations/In Kind"?
PS - I still plan on using Doctor Who references during all of my building and tweaking.
Bookmarks