+ Reply to Thread
Results 1 to 4 of 4

Cannot set an individual link from a list item

  1. #1
    Registered User
    Join Date
    11-01-2022
    Location
    Eastbourne
    MS-Off Ver
    365
    Posts
    17

    Cannot set an individual link from a list item

    Hi

    Can the expert's on here advise me on something i thought may have been easy but I was wrong. I have created a list (data validation) is there anyway of linking every item in the list to an individual file as at the moment when i select the first item it goes to the file but when i select the next item it goes to the same file or is there a way of selecting an item in the list so it opens a comment box the problem is i dont want to use any macros. the idea is that once an item is selected in the list it brings up something that contains text whether it be a word text file or a comment box. Any help or advise would be appreciated.

  2. #2
    Valued Forum Contributor
    Join Date
    10-17-2007
    Location
    Tasmania, Australia
    MS-Off Ver
    2019, 365(v2310)
    Posts
    366

    Re: Cannot set an individual link from a list item

    Are you able to upload a sample file. Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

  3. #3
    Registered User
    Join Date
    11-01-2022
    Location
    Eastbourne
    MS-Off Ver
    365
    Posts
    17

    Re: Cannot set an individual link from a list item

    Hi

    I dont have any file as i have not started yest was just testing the water if I did upload a file all it would have is an excel column with a data validation
    list .There is 3 items in the list what im looking for is a way to click on an item in that list that either opens a comments box or goes to a file when i have tried it
    evry item goes to the same file as if it is one link sorry if i have not explained to well

  4. #4
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2308
    Posts
    1,472

    Re: Cannot set an individual link from a list item

    I don't believe you can do this without some sort of VBA. The only way "around this" would be to use a combination of something like IF() and HYPERLINK() functions and have it reference the data validation list cell.
    <----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.

+ 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] Issues with Macro to create individual pdf files for each item on item validation list
    By maldo81 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-10-2021, 02:58 PM
  2. Replies: 6
    Last Post: 06-23-2019, 11:07 PM
  3. Replies: 2
    Last Post: 12-14-2016, 12:20 AM
  4. Using If statement to link item number and item from two different sheets
    By jaylahaye1974 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-14-2015, 09:43 AM
  5. Unable to link pivot table item in field list to value in a cell
    By VBAprogrammer3502 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-20-2013, 11:13 AM
  6. Replies: 2
    Last Post: 02-29-2012, 03:57 AM
  7. Create new sheet for each individual item
    By Javan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-13-2008, 02:03 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