Results 1 to 3 of 3

Macro help to create sequntials links as count given in specific column

Threaded View

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

    Macro help to create sequntials links as count given in specific column

    Hi Friends,

    Can you help me create a macro for a problem. Number of Pages Needed means I need links to be created in Sequence for that link as shown in Solution. If number of pages says 8 then sequential link should be created starting from page= 1 till page = 8

    Problem
    Links Num of Pages Needed Links
    Link 1 8 Included=101165590&industryIncluded=14&logHistory=true&page=1
    Link 2 9 Included=101165590&industryIncluded=11&logHistory=true&page=1
    Link 3 10 Included=101165590&industryIncluded=12&logHistory=true&page=1
    Link 4 3 Included=101165590&industryIncluded=14&logHistory=true&page=1
    Link 5 5 Included=141165590&industryIncluded=14&logHistory=true&page=1
    Link 6 3 Included=1225590&industryIncluded=14&logHistory=true&page=1

    Solution
    Links Links
    Link 1 Included=101165590&industryIncluded=14&logHistory=true&page=1
    Link 1 Included=101165590&industryIncluded=14&logHistory=true&page=2
    Link 1 Included=101165590&industryIncluded=14&logHistory=true&page=3
    Link 1 Included=101165590&industryIncluded=14&logHistory=true&page=4
    Link 1 Included=101165590&industryIncluded=14&logHistory=true&page=5
    Link 1 Included=101165590&industryIncluded=14&logHistory=true&page=6
    Link 1 Included=101165590&industryIncluded=14&logHistory=true&page=7
    Link 1 Included=101165590&industryIncluded=14&logHistory=true&page=8
    Link 2 Included=101165590&industryIncluded=11&logHistory=true&page=1
    Link 2 Included=101165590&industryIncluded=11&logHistory=true&page=2
    Link 2 Included=101165590&industryIncluded=11&logHistory=true&page=3
    Link 2 Included=101165590&industryIncluded=11&logHistory=true&page=4
    Link 2 Included=101165590&industryIncluded=11&logHistory=true&page=5
    Link 2 Included=101165590&industryIncluded=11&logHistory=true&page=6
    Link 2 Included=101165590&industryIncluded=11&logHistory=true&page=7
    Link 2 Included=101165590&industryIncluded=11&logHistory=true&page=8
    Link 2 Included=101165590&industryIncluded=11&logHistory=true&page=9
    Link 3 Included=101165590&industryIncluded=12&logHistory=true&page=1
    Link 3 Included=101165590&industryIncluded=12&logHistory=true&page=2
    Link 3 Included=101165590&industryIncluded=12&logHistory=true&page=3
    Link 3 Included=101165590&industryIncluded=12&logHistory=true&page=4
    Link 3 Included=101165590&industryIncluded=12&logHistory=true&page=5
    Link 3 Included=101165590&industryIncluded=12&logHistory=true&page=6
    Link 3 Included=101165590&industryIncluded=12&logHistory=true&page=7
    Link 3 Included=101165590&industryIncluded=12&logHistory=true&page=8
    Link 3 Included=101165590&industryIncluded=12&logHistory=true&page=9
    Link 3 Included=101165590&industryIncluded=12&logHistory=true&page=10
    Link 4 Included=101165590&industryIncluded=14&logHistory=true&page=1
    Link 4 Included=101165590&industryIncluded=14&logHistory=true&page=2
    Link 4 Included=101165590&industryIncluded=14&logHistory=true&page=3
    Link 5 Included=141165590&industryIncluded=14&logHistory=true&page=1
    Link 5 Included=141165590&industryIncluded=14&logHistory=true&page=2
    Link 5 Included=141165590&industryIncluded=14&logHistory=true&page=3
    Link 5 Included=141165590&industryIncluded=14&logHistory=true&page=4
    Link 5 Included=141165590&industryIncluded=14&logHistory=true&page=5
    Link 6 Included=1225590&industryIncluded=14&logHistory=true&page=1
    Link 6 Included=1225590&industryIncluded=14&logHistory=true&page=2
    Link 6 Included=1225590&industryIncluded=14&logHistory=true&page=3


    Thanks...
    Last edited by hjaspaul; 08-18-2020 at 01:12 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 11-15-2019, 11:53 AM
  2. Create macro that will run if any cell in specific column is filled
    By andikasahab in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-08-2016, 03:46 AM
  3. Replies: 2
    Last Post: 12-17-2013, 06:30 AM
  4. Create a macro using data enterd in a specific cell to filter a worksheet column
    By jdunbarjr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-22-2013, 10:39 PM
  5. Create a macro using data enterd in a specific cell to filter a worksheet column
    By jdunbarjr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-21-2013, 09:42 PM
  6. New Member - Looking for specific tutorials for specific macro? Links please?
    By RDAmidwest in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2012, 12:14 PM
  7. How to create a macro to hide specific rows where 1st column contains merged cells
    By ascottbag in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-27-2011, 01:16 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