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
Bookmarks