I have a Data Validation List in cell A8 containing names - Name1, Name2, Name3 etc. I'm wanting to link each name to elsewhere on the sheet. In my case, Name1 links to M3, Name2 links to W3, Name3 links to AG3 and so on - they're linking to cells that are 10 cells to the right of the previous. When the user makes their selection, I also like that to automate without the need to click again on the link.
Is this possible?
Is this possible?