Please see the sample file. The sample file only contains sample data with 3 rows of input, the macro should run until all rows in column A to D are processed.
Column A is not used in the macro, but is for naming only.
Column B contains a URL
Column C & D contains the starting and ending number to be appended to the URL in Column B. Each number is to be appended in sequence until the ending number is met.
The output of all URL's is to be put in column F.
Excel and VBA expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my portfolio for: [url removed, login to view] Estate (video demonstration) [url removed, login to view] (video demonstrat Mere
20 freelancers are bidding on average $24 for this job
Hi, I'll be happy to help you with this macro now. I will finish it within 15 mins! Please feel free to message me if you need to discuss any questions you might have prior to award
My bid includes also the macro doing the job for the case you need it for repetitive use. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards
Hi: Here's your working macro: [url removed, login to view] Just Download the file and see that it meets your requirements. Please pay me if you want to otherwise happy to help.
Free of charge lastrow=cells([url removed, login to view],"B").end(xlup).row nextrow=cells([url removed, login to view],"F").end(xlup).row set rng=range(cells(1,"B"), cells(lastrow,"B")) for each c in rng for i=[url removed, login to view](0,1) to [url removed, login to view](0,2) Mere
Hi, I can help you with your assignment. I just reviewed the sample file url in column b is different from column F. Can you specify the logic for the macro. Regards Sawan