How to Create a link to another worksheet

[clifford_ayala]

Hi Guys im currently working on contact details for each of our client. Attached here is the sample worksheet im currently working on. As the title suggest is it possible if i click the company name i will be directed to its contact details on the other sheet? any suggestion please? we need a worksheet that functions like this: if we click the company name, it will direct the user to its contact details or will display ONLY its contact details. open for any suggestion that works similar with this.

[:) Sixthsense :)]

But there is no company name column found in CONTACT DETAILS sheet

[clifford_ayala]

But there is no company name column found in CONTACT DETAILS sheet

Yes bro, only the account name/number will be the basis...sample desired output is that when i click the company name on sheet 1, i will be linked/display the contact details found on sheet 2...so far any suggestions that works similar on this is highly appreciated :D

[:) Sixthsense :)]

Still my question is not answered

Abc needs to be linked with which contact since there is already four records for 123.

At the same time there is no Abc is found in that Four records of 123.

[clifford_ayala]

Still my question is not answered

Abc needs to be linked with which contact since there is already four records for 123.

At the same time there is no Abc is found in that Four records of 123.

ACCOUNT NAME and COMPANY NAME is connected, we use ACCOUNT NAME to identify the company in this case Abc company needs to be linked with 123 ( account name of Abc )

There goes my problem: if i was thinking a way for it to be linked with those four records ( either drop down list on Abc company name or link button )

All in all the desired outcome is:

If we Click or select any of the company names of the list -> it wil display all its contact details on the other side of the sheet using its account name as point of reference.

hope that helps bro..sorry im bad at explaning this, let me know if there is something i need to explain :D

[:) Sixthsense :)]

Ok.. fine and thanks for the brief

Just one question why don't we link it with the Account # itself instead of thinking to do it with Company name?

[clifford_ayala]

Ok.. fine and thanks for the brief

Just one question why don't we link it with the Account # itself instead of thinking to do it with Company name?

haha sorry about my misleading description XD

hmmm its because our team lead thinks it is easier to present if we could link it out via company name..though i really liked that idea of yours, maybe we can try it to if linking to via company name would prove way too difficult

[:) Sixthsense :)]

Copy the below code and do right click on COMPANY NAME sheet tab and select view code and paste the below code. Close the VBA window (Alt+Q to close VBA window) and return to that sheet and place the cursor in B2 cell and move it between B2:B7 cella and check.

Please Login or Register  to view this content.

Refer the attached file for details

[clifford_ayala]

^ cool currently checking on this yay ~

[clifford_ayala]

^ cool currently checking on this yay ~ :D

[clifford_ayala]

nice one sir..it works perfectly and very presentable this way than drop down list :D...again thank you very much ~

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback and rep

Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding.

Please click Edit on Post 10 and remove my quotes.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[clifford_ayala]

^ Thanks sir sorry about that though, while at it i'd like to ask on how to delete a certain post? i cant seem to find the delete post button and im only seeing edit one XD..i'd like to delete my double post on #9

[:) Sixthsense :)]

Under the Post #9 click the Report Post button and in the next window it will ask you to mention the reason.

Just mention double posted and it will hit the moderators/admin inbox and they will take the necessary action against that post

[jamzsaludares]

I have to bookmark this.
Tnx

[clifford_ayala]

Noted. Thanks again ~