+ Reply to Thread
Results 1 to 3 of 3

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

  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.

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

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

    Excel sample attached. Problem is in Problem Tab and Solution requested in shown in Solution tab
    Attached Files Attached Files

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

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

    Hello Friends. Can anyone please help me with the request?

+ 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. 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