Yes, sure
I do this all the time
Now, the link you have may look like this
http://www.file1.net/project.asp?id=89
If this link in cell A1, then paste this in B1
=LEFT(A1, SEARCH("?",A1)-1)
This will bring you the first part until the "?"
Then in another cell, say C1 type 5
Then in D1 paste this
=HYPERLINK( B1&"id="&C1, B1)
Now this link will have this result
http://www.file1.net/project.asp?id=5
So doing 6 in C2, 7 in C3, etc
Copy and paste D1 down to generate multiple hyperlinks to different locations based on your criteria
I did this as example, because you didn't give any details
try applying your criteria and see
VBAXLMan is here to feed your Excel needs in case you want more help