hi
i would like to create a colume of hyperlinks that when i click any of the cells in that colume it opens the matching sheet in another place.
without having to set the hyperlink manuleyl.
i wuld put a number like 123 in a1 then when i click it it would open up axlsx sheet that i have somwere else
i hope this makes sencs