Macro to get sequential links

[hjaspaul]

Hello Friends.

Can you please help me to create a macro. I have few links and need a sequential series for those links(one below anoher). For example I have numbers with me how many sequence I need to create for a particular link.
For first link I need 3 incremental links for that, for second link count is 2 and for third count is 5. as shown in example below.


Problem
3 aabbcc.com&logHistory=true&page=1&searchlogreport
2 depp.com&logHistory=true&page=1&searchlogreport
5 hahfs.com&logHistory=true&page=1&searchlogreport

Solution
aabbcc.com&logHistory=true&page=1&searchlogreport
aabbcc.com&logHistory=true&page=2&searchlogreport
aabbcc.com&logHistory=true&page=3&searchlogreport
depp.com&logHistory=true&page=1&searchlogreport
depp.com&logHistory=true&page=2&searchlogreport
hahfs.com&logHistory=true&page=1&searchlogreport
hahfs.com&logHistory=true&page=2&searchlogreport
hahfs.com&logHistory=true&page=3&searchlogreport
hahfs.com&logHistory=true&page=4&searchlogreport
hahfs.com&logHistory=true&page=5&searchlogreport

[vba_php]

all you have to do it read the first byte of data in your first list, line by line and use it as a counter to copy the rest of that line's data multiple times to a new table below it or on a new worksheet. you can make use of the following functions:

=> LEFT()
=> MID()
=> RIGHT()
=> RANGE()

if you're participating in a web scraping project though, be aware that some website have policies stating that they do not allow it. However, I don't think they can do much about it if you violate those terms. Just saying....resources have to be used to monitor activity like that.

[jindon]

Assuming data in Col.A, output in col.C

Please Login or Register  to view this content.

[hjaspaul]

Thanks Adam, but I have a huge list and breaking it down to formulae for each col will be too much manual work, so that why only macro can help here to expedite. Thankyou for helping me here.

Thanks for help jindon but macro is not working. Just showing a sample in snapshot how the outcome should look like. The only thing which will change in each link is number in page. speerate links will be created based on col A value and it should be like page = 1, page = 2, page = 3 will be the only diff in each link. Thanks for helping me with your precious knowledge and time.

Attachment 692163

[vba_php]

hjas,

jindon can probably help you out, but just so you know, like everyone I've told so many times, whenever you upload images the way you did, for some reason I cannot see them. here is what I see. can you upload it another way?

[hjaspaul]

Sorry,

here is the excel sheet attached

[jindon]

I thought
3 aabbcc.com&logHistory=true&page=1&searchlogreport
is in one cell...

Change to

Please Login or Register  to view this content.

[hjaspaul]

Thanks Jindon, it is not working for me. Sorry to be naive but I am attaching the file. Can you please see am I missing something here or doing something incorrectly.

[jindon]

The code should be in a standard code module, not in Class module.

[hjaspaul]

Thanks Jidon. Yes this is working. And thanks for guiding me.
Just slight tweak is needed. For second link page numbers should increase. For increase first link will have page=1, second link will have page=2, third link will have page=3, and everyhting else in the sting should remain the same

3 aabbcc.com&logHistory=true&page=1&searchlogreport
2 depp.com&logHistory=true&page=1&searchlogreport
5 hahfs.com&logHistory=true&page=1&searchlogreport

Solution
aabbcc.com&logHistory=true&page=1&searchlogreport
aabbcc.com&logHistory=true&page=2&searchlogreport
aabbcc.com&logHistory=true&page=3&searchlogreport
depp.com&logHistory=true&page=1&searchlogreport
depp.com&logHistory=true&page=2&searchlogreport
hahfs.com&logHistory=true&page=1&searchlogreport
hahfs.com&logHistory=true&page=2&searchlogreport
hahfs.com&logHistory=true&page=3&searchlogreport
hahfs.com&logHistory=true&page=4&searchlogreport
hahfs.com&logHistory=true&page=5&searchlogreport

[hjaspaul]

Format of links are different, it is not necessary that links will have same format. for the entire link I just need Page=1 count to increase and nothing else. You are very close to solution, thanks again for the time and my silly queries.

[jindon]

It is working as it is.

[hjaspaul]

I gave this seperate link
def/243288?doFetchHeroCard=false&functionIncluded=4%2C13%2C16%2C15%2C25%2C19%2C20%2C8%2C9&geoIncluded=101165590&logHistory=true&page=1&searchSessionId=famXfD2oTsG%2B67Uge9wixw%3D%3D&seniorityIncluded=4%2C6%2C9%2C7%2C10%2C8%2C5


Output I am getting for this is below 2 links, where only geoIncluded=1 and geoIncluded=2 are getting reflected instead of page =1 and page=2...The sequence of these links are going to be changed, and only page sysntax is the only main thing which will give incremental sequence to the link.
def/243288?doFetchHeroCard=false&functionIncluded=4%2C13%2C16%2C15%2C25%2C19%2C20%2C8%2C9&geoIncluded=1&logHistory=true&page=1&searchSessionId=famXfD2oTsG%2B67Uge9wixw%3D%3D&seniorityIncluded=4%2C6%2C9%2C7%2C10%2C8%2C5
def/243288?doFetchHeroCard=false&functionIncluded=4%2C13%2C16%2C15%2C25%2C19%2C20%2C8%2C9&geoIncluded=2&logHistory=true&page=1&searchSessionId=famXfD2oTsG%2B67Uge9wixw%3D%3D&seniorityIncluded=4%2C6%2C9%2C7%2C10%2C8%2C5

[jindon]

Can you just upload a data that you are working with and the result that you want in a workbook?

[hjaspaul]

File sample attached. The only thing which change in all links is pagenumbers. page=1, page=2, page =3 (everything else remains the same) based on the value mentioned in Col A w.r.t link in Col B

[jindon]

For the data attached.

Please Login or Register  to view this content.

[hjaspaul]

Sir you are Awesome. Thanks for your valuable Time and help.