+ Reply to Thread
Results 1 to 3 of 3

Automatic URL Links creation and page distribution

  1. #1
    Registered User
    Join Date
    04-14-2016
    Location
    New Delhi
    MS-Off Ver
    2013
    Posts
    44

    Automatic URL Links creation and page distribution

    Respected Seniors

    Kindly help me to build the macro. My requirement is in Input tab I have two columns ID and Total.

    For example Id is 1862000 and Total is 327 then I should get URL with below sequence, where Total is divided by 25 and a unique link is created where ID remains constant but start = 0 and keep on increment by 25 till reaches final division level.
    search?value=CC&facet.CC=1862000&count&start=0
    search?value=CC&facet.CC=1862000&count&start=25
    search?value=CC&facet.CC=1862000&count&start=50
    search?value=CC&facet.CC=1862000&count&start=75
    search?value=CC&facet.CC=1862000&count&start=100
    search?value=CC&facet.CC=1862000&count&start=125
    search?value=CC&facet.CC=1862000&count&start=150
    search?value=CC&facet.CC=1862000&count&start=175
    search?value=CC&facet.CC=1862000&count&start=200
    search?value=CC&facet.CC=1862000&count&start=225
    search?value=CC&facet.CC=1862000&count&start=250
    search?value=CC&facet.CC=1862000&count&start=275
    search?value=CC&facet.CC=1862000&count&start=300
    search?value=CC&facet.CC=1862000&count&start=325
    search?value=CC&facet.CC=1862000&count&start=350

  2. #2
    Registered User
    Join Date
    04-14-2016
    Location
    New Delhi
    MS-Off Ver
    2013
    Posts
    44

    Re: Automatic URL Links creation and page distribution

    Input tab looks like -
    ID Total
    1862000 327
    62000 58
    137000 40

    And output tab should look like -
    Links
    search?value=CC&facet.CC=1862000&count&start=0
    search?value=CC&facet.CC=1862000&count&start=25
    search?value=CC&facet.CC=1862000&count&start=50
    search?value=CC&facet.CC=1862000&count&start=75
    search?value=CC&facet.CC=1862000&count&start=100
    search?value=CC&facet.CC=1862000&count&start=125
    search?value=CC&facet.CC=1862000&count&start=150
    search?value=CC&facet.CC=1862000&count&start=175
    search?value=CC&facet.CC=1862000&count&start=200
    search?value=CC&facet.CC=1862000&count&start=225
    search?value=CC&facet.CC=1862000&count&start=250
    search?value=CC&facet.CC=1862000&count&start=275
    search?value=CC&facet.CC=1862000&count&start=300
    search?value=CC&facet.CC=1862000&count&start=325
    search?value=CC&facet.CC=1862000&count&start=350
    search?value=CC&facet.CC=62000&count&start=0
    search?value=CC&facet.CC=62000&count&start=25
    search?value=CC&facet.CC=62000&count&start=50
    search?value=CC&facet.CC=62000&count&start=75
    search?value=CC&facet.CC=137000&count&start=0
    search?value=CC&facet.CC=137000&count&start=25
    search?value=CC&facet.CC=137000&count&start=50

  3. #3
    Registered User
    Join Date
    04-14-2016
    Location
    New Delhi
    MS-Off Ver
    2013
    Posts
    44

    Re: Automatic URL Links creation and page distribution

    Any suggestions please

+ 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. Automatic Web Data Query Creation
    By basalisbury in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-04-2012, 06:39 AM
  2. Automatic creation of worksheets
    By AC1961 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-18-2010, 04:30 AM
  3. Replies: 2
    Last Post: 10-23-2010, 08:36 AM
  4. Automatic New Sheet Creation
    By BudParker in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-19-2009, 09:02 AM
  5. Automatic table creation
    By sanjimmy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-12-2008, 08:18 AM
  6. automatic graph creation
    By Junne in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-06-2007, 03:25 AM
  7. creation of automatic hypertext links
    By christopherocca in forum Excel General
    Replies: 2
    Last Post: 05-12-2006, 03:45 AM
  8. [SOLVED] [SOLVED] multiple links creation error
    By Devin D in forum Excel General
    Replies: 0
    Last Post: 04-19-2006, 11:25 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