• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

links

H

htonamie

New Member
I have a spreadsheet that contains all of the departments within my company. Each department has a list of personnel within the department. I want to create a link or hyperlink for each department that when clicked will display the names of all the personnel within the department. Is there a way to do this in excel?
 
As a tip says: Upload a Sample File to get a quicker response
... many things would be possible after that
 
Give each department a sheet (name the sheet with department name for easy reference by you)in that sheet put a departments names/data, then create a link sheet with all department names, names will be a hyperlink to individual sheets. This will enable quick access to department lists and data. Links can be placed in any other work sheets.
 
You must log in or register to reply here.
Back
Top