The basic concept,
Click a cell on a page and it will jump to the Tab for that PI colony containing information about the colony and the market data on the products.
HYPERLINK(‘COLONY1!A1’,”Colony 1”) as I understand this is the basic concept of the formula within the same workbook. There would be 6 tabs one for each colony.
When I tried it the first time it worked as advertised, but once saved, exited and tried the next day, it opens a new tab in my web browser and advertises about OneDrive.
Any ideas?