Hi,
I need help with inserting multiple hyperlinks in a single column and be able to auto create the link by typing a particular code. For eg; in 'entrybook2', under dyer column I have entered codes like ma, rz, jd. I require that if I type ma, it should directly go to the worksheet 'Mohammad Ali Dyer' to pcs received sheet. Similarly, if I type rz and jd, should go directly to their respective sheets. I should not need to insert hyperlink each and everytime I make an entry.
Is this possible?
Bookmarks