+ Reply to Thread
Results 1 to 19 of 19

hyperlink table to table in another sheet

  1. #1
    Registered User
    Join Date
    12-16-2014
    Location
    India
    MS-Off Ver
    2010
    Posts
    14

    hyperlink table to table in another sheet

    Hi,

    I have two tables in two sheets, second table contains little bit big data.How can i put hyperlinks in first table, so it will point to the corresponding cell in table 2.

    I created one hyperlink but when i auto filled hyperlink column,all are pointing to same cell in table 2.

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: hyperlink table to table in another sheet

    The formula in the hyperlink needs to refer to a relative cell reference. In other words, if the reference to the cell number for table 2 has $ signs in it, delete them. For example, if it looks like $C$5 change it to C5.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

  3. #3
    Registered User
    Join Date
    12-16-2014
    Location
    India
    MS-Off Ver
    2010
    Posts
    14

    Re: hyperlink table to table in another sheet

    Quote Originally Posted by tuph View Post
    The formula in the hyperlink needs to refer to a relative cell reference. In other words, if the reference to the cell number for table 2 has $ signs in it, delete them. For example, if it looks like $C$5 change it to C5.
    Thanks Tuph, I created hyperlink by right clicking & selecting hyperlink. In the cell reference field there is no $ sign, only exact cell name in the second sheet.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: hyperlink table to table in another sheet

    What does your HL formula look like?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Registered User
    Join Date
    12-16-2014
    Location
    India
    MS-Off Ver
    2010
    Posts
    14

    Re: hyperlink table to table in another sheet

    I don't have any formula in hyperlink, i created hyperlink by right clicking cell, in the cell reference field there are no $ signs. Can I make one hyperlink & pull it via autofiill ?

    What I require is as we click on link on parts column, it should point to corresponding cell in the detailed parts column on another sheet on the same workbook.


    Thanks Ford for replying, i was waiting for a reply

    untitled.JPG
    Attached Images Attached Images
    Last edited by rahulsureshonline; 12-18-2014 at 03:11 AM.

  6. #6
    Registered User
    Join Date
    12-16-2014
    Location
    India
    MS-Off Ver
    2010
    Posts
    14

    Re: hyperlink table to table in another sheet

    sorry for that fruits sheet, it came with that.

  7. #7
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: hyperlink table to table in another sheet

    Instead of hyper linking the cells manually you can simply use hyperlink formula which will create hyperlink to source cell automatically.

    Please attach a file instead of picture so that we can able to add the formula in your file and show it to you


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  8. #8
    Registered User
    Join Date
    12-16-2014
    Location
    India
    MS-Off Ver
    2010
    Posts
    14

    Re: hyperlink table to table in another sheet

    Thanks a lot sixthsense, I am attaching file. Hope you will look into it.
    Attached Files Attached Files

  9. #9
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: hyperlink table to table in another sheet

    Can you please describe which needs to be hyperlinked with which cell/sheet?

  10. #10
    Registered User
    Join Date
    12-16-2014
    Location
    India
    MS-Off Ver
    2010
    Posts
    14

    Re: hyperlink table to table in another sheet



    Hi,

    Parts used column will be filled with hyperlinks. Parts sheet will have date,C#,address & parts columns. So if i click third link , it will point to third cell in the parts column in parts list.

  11. #11
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: hyperlink table to table in another sheet

    Quote Originally Posted by rahulsureshonline View Post
    Parts sheet will have date,C#,address & parts columns
    But your attachment is missing the date,C#,address in Parts Sheet

    So unable to compare which part belongs to which data.

    So please show a valid file for us so that we can give you the exact solution

  12. #12
    Registered User
    Join Date
    12-16-2014
    Location
    India
    MS-Off Ver
    2010
    Posts
    14

    Re: hyperlink table to table in another sheet

    Sorry, after replying I thought about the other columns.One more help i requested in repeated complaints sheet.
    Attached Files Attached Files

  13. #13
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: hyperlink table to table in another sheet

    For 1235 G+2 Rolla

    Which cell should be considered for hyperlink in the below case?

    1235 G+2 Rolla BB
    1235 G+2 Rolla AA

    Why don't you keep the Parts Sheet data in Sorted List?

  14. #14
    Registered User
    Join Date
    12-16-2014
    Location
    India
    MS-Off Ver
    2010
    Posts
    14

    Re: hyperlink table to table in another sheet

    I made this sample sheet to learn how to hyperlink, I copy paste fields to make this sheet so it is not in an order. I am an excel newbie, i dont know how to make sheets more productive. Fields in the first sheet are the fields going to be in my real sheet, data I entered was just for learning the hyperlinks & conditional formatting

  15. #15
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: hyperlink table to table in another sheet

    If you just want to know how to use Hyperlink() (rather than expecting us to give you the exact hyperlink solution for your file) then go through the below link and download the file from post #1

    http://www.excelforum.com/tips-and-t...earned-12.html

    After downloading open the file and locate the sheet named as 1 in which you can get the further info about Hyperlink() function usage

  16. #16
    Registered User
    Join Date
    12-16-2014
    Location
    India
    MS-Off Ver
    2010
    Posts
    14

    Re: hyperlink table to table in another sheet

    Quote Originally Posted by :) Sixthsense :) View Post
    If you just want to know how to use Hyperlink() (rather than expecting us to give you the exact hyperlink solution for your file) then go through the below link and download the file from post #1

    http://www.excelforum.com/tips-and-t...earned-12.html

    After downloading open the file and locate the sheet named as 1 in which you can get the further info about Hyperlink() function usage

    By looking at the hyperlinks in the tutorial I am bit confused, I am attaching file with my requirements in the second sheet of file.
    Attached Files Attached Files

  17. #17
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: hyperlink table to table in another sheet

    Quote Originally Posted by :) Sixthsense :) View Post
    If you just want to know how to use Hyperlink() (rather than expecting us to give you the exact hyperlink solution for your file) then go through the below link and download the file from post #1

    http://www.excelforum.com/tips-and-t...earned-12.html

    After downloading open the file and locate the sheet named as 1 in which you can get the further info about Hyperlink() function usage
    Thanks for the redirect Sixthsense. I cannot say enough good thinks about that tutorial / file.

  18. #18
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: hyperlink table to table in another sheet

    Quote Originally Posted by rahulsureshonline View Post
    By looking at the hyperlinks in the tutorial I am bit confused, I am attaching file with my requirements in the second sheet of file.
    Formula for your Post #16 Attachment file


    In H2 Cell of Maintenance Sheet


    =HYPERLINK("#'Parts'!E"&LOOKUP(2,1/((Table3[[Date ]]=[@[Date ]])*(Table3[C'#]=[@[C'#]])*(Table3[Address]=[@Address])*(Table3[Type]=[@[Type ]])),ROW(Table3[Parts used])),INDIRECT("'Parts'!E"&LOOKUP(2,1/((Table3[[Date ]]=[@[Date ]])*(Table3[C'#]=[@[C'#]])*(Table3[Address]=[@Address])*(Table3[Type]=[@[Type ]])),ROW(Table3[Parts used]))))

  19. #19
    Registered User
    Join Date
    12-16-2014
    Location
    India
    MS-Off Ver
    2010
    Posts
    14

    Re: hyperlink table to table in another sheet

    Thanks Sixthsense, now whatever I am typing in parts list is appearing in main sheet as link. So main sheet column field will grow big same as detailed parts column.


    I need to place a single word like "Click" which will point to corresponding detailed parts column cell.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] copy sheet based on table, rename, and hyperlink table to new sheet
    By DrZeuss in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-30-2014, 01:18 PM
  2. Replies: 0
    Last Post: 05-08-2014, 11:59 AM
  3. Replies: 3
    Last Post: 01-07-2014, 06:13 AM
  4. Replies: 3
    Last Post: 11-29-2013, 11:52 AM
  5. Replies: 0
    Last Post: 10-30-2012, 06:42 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1