Ms. Excel: Update a value in a named range
- by Vinzz
Hi,
I've got some cells in an Excel doc populated from a named range (data/validation/list source=MyNamedRange)
My problem is the following: I'd like to change a value in the named range, then see this value updated in my whole doc.
It might be performed through a macro, but I don't know how to code this.
Any hints please?
Thanks,