+ Reply to Thread
Results 1 to 4 of 4

Put urls to different cells using the number in the cell

  1. #1
    Registered User
    Join Date
    08-21-2013
    Location
    Greece
    MS-Off Ver
    Excel 2016
    Posts
    18

    Put urls to different cells using the number in the cell

    Hello,

    for someone with experience i think that there is an easy solution to the below problem i have.
    in column A i have some codes for each of my jobs. The link is the same to all these jobs and the only think that changes is the number
    One example is https://services.anavasis.gr/Adminis...say/Edit/16518
    so how can i generate to all cell in the column the same url only changing the number in the end with the number in the cell?

    Code
    16518
    19465
    19418
    19242
    19403
    19120
    19207
    19333
    19117
    19517
    19551
    19438
    19457
    19424
    19286
    19150
    19177
    19150
    19177
    19308
    19313
    19471
    19410
    19499
    19387

    Lets say this is the column and the url for the first cell is https://services.anavasis.gr/Adminis...say/Edit/16518
    how can i automatically generate links to the other cells only changing the number

    Thanks

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,440

    Re: Put urls to different cells using the number in the cell

    Hi,

    How about this..

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Registered User
    Join Date
    08-21-2013
    Location
    Greece
    MS-Off Ver
    Excel 2016
    Posts
    18

    Re: Put urls to different cells using the number in the cell

    Thanks
    how can i use the formula?

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Put urls to different cells using the number in the cell

    My suggestion to use what sweep gave you is to put it in an adjacent empty cell like B1, then double click the bottom corner and it will copy down for your entire list.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

+ 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] Replace image URLs in cells with photos?
    By Whatman in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-10-2018, 01:43 AM
  2. How Do I Extract URLs from one set of cells and Insert into another set of cells
    By mixonenterprises in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-01-2014, 04:37 PM
  3. Need help with macro to automate web queries (with URLs in cells)
    By BBallExcel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-25-2013, 01:46 PM
  4. EXCEL VBA: web query from a list of URLs within cells
    By IDONTTELLYOU in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2012, 01:10 AM
  5. extracting URLs from cells and copying to another
    By RichAutechre in forum Excel General
    Replies: 2
    Last Post: 09-29-2011, 02:28 PM
  6. Add URLs based on number of images
    By Ocean Zhang in forum Excel General
    Replies: 2
    Last Post: 08-04-2011, 12:29 PM
  7. Converting text URLs to hyperlinked URLs
    By ranchhand in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-25-2011, 01:46 PM

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