I created my hyperlinks using =Hyperlink(,). I did this because I want the hyperlink to have text that can be pulled from a column and link that can be pulled from another column. This will allow the updating of the names and links from a master sheet routinely without need to go into all of the sheets that pull the same data. I can't get (Insert > Hyperlink) to pull the data from my existing columns. Am I missing something? Is there a way to use (Insert>Hyperlink) to pull from existing columns?