Hi, I'm not sure if this is possible, so I thought I would cast a wide net. Description: I have an Excel spreadsheet with many sheets of summary and detail information of employees. On a summary sheet, I have rows that list job titles and the quantity of employees with that job title in the adjacent cell. I'd like to click on the summary number, and then change to the detail sheet that shows just the employees with that job title. My data is in Tables. I have already programmed setting and clearing filters and navigating about the sheets, updating SQL, so I could create a sub that does what I want, but I don't know what to search about clicking a cell then start the process. Visually I'd like something simple like a hyperlink. The part that I don't know if possible is the click on a cell then have something happen. TIA Rob
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
