Hello, I hope you are all having great days. I'd love to find out how I can insert a hyperlink from, say, cell B10 to a drawing object on a different worksheet in the same workbook. For example, I have a list of 330 items on sheet 1, with various information across 10 different columns. I have a drawing on sheet 7 that is basically a top view map of where the items are physically located in the warehouse. I would like to hyperlink cells from B column to each individual drawing object to show their location on that top view map. As well, for some real icing on the cake, I'd like to have that map have the objects change colors according to the color doing in sheet 1, but it would be awesome to do this embedded and linked, or whatever it is that does it automatically from sheet one without input from me.

Highest regards guys...