Use this trick to create use the same Named Range across multiple worksheets, but with each worksheet holding a different value Read More