ExcelHelp
23

Hi,
Some of us should be aware of hyperlink feature in excel. But Microsoft has provided a seperate function called HYPERLINK like SUM, AVERAGE function. Why did they do so? There might be some thought process behind it, right?
That's what we are digging into this week.
Scenario which we have taken here is, we have three different department files where
people have to update their department file by simply selecting their department in a drop down and clicking on a link.
Check out the attachments which illustrates how we solved this requirement using hyperlink function.
Hope this illustration would give you some idea, where you can make use of HYPERLINK function in your work.
Wish you a great week ahead...
With best regards,
Hariharan Ramakrishnan
Microsoft Office Applications Trainer / Consultant

From India, Chennai
Attached Files (Download Requires Membership)
File Type: xls ADMIN.xls (23.5 KB, 672 views)
File Type: xls FINANCE.xls (23.5 KB, 538 views)
File Type: xls HR.xls (23.5 KB, 857 views)
File Type: xls Master Report With Hyperlink Function.xls (19.0 KB, 841 views)
File Type: pdf Using Hyperlink Function To Open User Chosen File1.pdf (539.8 KB, 345 views)

Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.