LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default CLICK THEN GO TO NAME ON SEPARATE WORKSHEET

I have two worksheets:


1st Worksheet named, "Contact Master"
Contact Master

COMPANY Position Name
FD Roustabout Albarado, Justin
FD Welder Atchley, Brian
FD ABCO Bailey, Jason

2nd Worksheet named "Master Schedule"
Name Position
Arnold, Benjamin Roustabout
Sage, Richard Roustabout

I want to click on the name in contact master and have it take me to the
exact same name in the 2nd worksheet. When using hyperlink I am unable to
specify the specific name I want it to find.

Please help. I've been trying to figure this out for weeks. Vlookup and
Hlookup haven't worked.






 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I click on a cell on one worksheet and make it take me to another worksheet steve12345 New Users to Excel 7 November 5th 12 06:45 PM
how to merge separate worksheet Jane Excel Worksheet Functions 1 May 15th 07 04:31 AM
Using a Worksheet Form to add data to a separate worksheet databas Rawblyn Excel Worksheet Functions 3 March 7th 06 08:17 PM
How do I separate a worksheet into many files? Alicia Excel Discussion (Misc queries) 1 February 15th 06 07:08 PM
Copying Worksheet triggers Click event of combobox on another worksheet Robert[_20_] Excel Programming 0 January 23rd 04 07:40 PM


All times are GMT +1. The time now is 02:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"