+ Reply to Thread
Results 1 to 5 of 5

Generating urls in spreadsheet based on matching cells.

  1. #1
    Registered User
    Join Date
    03-03-2009
    Location
    Gainesville, FL
    MS-Off Ver
    Excel 2002 SP3
    Posts
    39

    Generating urls in spreadsheet based on matching cells.

    Hi,

    I am trying to create a spreadsheet for an online gift registry. They require that the spreadsheet have the photo's url's in a column. I already have the spreadsheet filled with my data. In the spreadsheet, Column D is filled with unique numbers, some with parenthesis, (ex. 52011, 52011(2), 34132, etc.) I also have a folder full of images that are similarly formatted as such
    "...\images\brand_name_52011.jpg". (They will be moved eventually to a webserver.) Each number in the column may or may not have a corresponding image. And the images may or may not have a corresponding number in the spreadsheet. Is there a way to generate a url automatically in a column that corresponds to the image with the matching number? And if it doesn't, just leave it blank?

    I found this and it seemed similar, but not the same.

    http://www.excelforum.com/excel-misc...-url-list.html

    I am completely new at this and don't know where to begin.

    Thanks in advance,

    Chris
    Last edited by giallofever; 03-05-2009 at 01:46 PM. Reason: Problem Solved / Clarified Title

  2. #2
    Registered User
    Join Date
    03-03-2009
    Location
    Auckland, New Zealand
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Generating urls in spreadsheet based on matching filenames.

    the hyperlink function should do the trick? have you tried it?

  3. #3
    Registered User
    Join Date
    03-03-2009
    Location
    Gainesville, FL
    MS-Off Ver
    Excel 2002 SP3
    Posts
    39

    Re: Generating urls in spreadsheet based on matching filenames.

    Quote Originally Posted by sarah.k View Post
    the hyperlink function should do the trick? have you tried it?
    I have tried it. The thing is, I want to create a link, and have part of the link reference a cell. Such as, the number in cell D5 is 43001, then the url in cell F5 should be,
    "http://www.website.com/images/brand_name_43001.jpg", but I need it to be automatic or a script or batch file because there will be over 25,000 items and it will change as items come and go. But it will always be one spreadsheet and one images folder. Maybe subfolders Thanks in advance.

  4. #4
    Registered User
    Join Date
    03-03-2009
    Location
    Auckland, New Zealand
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Generating urls in spreadsheet based on matching filenames.

    I've got that happening in my sheet.

    Please Login or Register  to view this content.
    In this case A1 is static and B2 is an incremented number. I could build that link up in any number of ways, including user defined functions and strings.

  5. #5
    Registered User
    Join Date
    03-03-2009
    Location
    Gainesville, FL
    MS-Off Ver
    Excel 2002 SP3
    Posts
    39

    Smile Re: Generating urls in spreadsheet based on matching filenames.

    Quote Originally Posted by sarah.k View Post
    I've got that happening in my sheet.

    Please Login or Register  to view this content.
    In this case A1 is static and B2 is an incremented number. I could build that link up in any number of ways, including user defined functions and strings.
    Thank you, this got me real close to what I need. I will be making a new thread for my next issue which is related to the same spreadsheet and will send you a link to see if you can help me with that as well. Thank you so much for your help.

    Chris

    SOLUTION FOR MY PROBLEM

    =HYPERLINK("http://www.website.com/registry_images/" & (C4) & "/" & (G4) & "/" & (C4) & "_" & (D4) & ".jpg")

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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