I keep having to do this over and over in excel. It is simple, but it takes up so much time.

Lets say i input in serial codes down the entire column of B.
And then add a comment for that serial in the same row, but in column D.
I need to add a hyperlink to every single serial, which is basiclly: www.example.com/12345
The 12345 is the serial number number in that cell (the first part never changes)
**It actualy says XX-12345 but i cant include the XX- into the hyperlink**

I then have to copy the hyperlinked serials and paste them into another workbook, lets say down Column A

Then take the corresponding comment and paste it in Column B

Is there a way where it can auto create the hyperlink for me and then take the hyperlinked serial and the comment with it and paste it in the other workbook? Would save me so much time.

Any questions, please let me know. It's hard to explain i know.