I have a spreadsheet where I select a switch in cell M5, I choose one of 5 regions.
For those regions I have a list of reports and distribution lists. I have these set up in the named ranges e.g SectorASP
What I would like is that when the I select Asia in M5, using vba perhaps, the name range SectorASP is copied over K5:L5 and down
So when a user selects a region, the corresponding distribution list (as defined by the named ranges) is copied into K5:L5