Hi, I'm very new to VBA and I've never done any sort of webscraping. I've tried looking on google and stackoverflow and I haven't been able to find anything that directly relates to my issue.

I have a column of unique characters called CUSIPS that correlate to bond names. I want to paste them into the search function of a bond website and pull the name of the bond out and paste it into the adjacent cell. I'm having trouble wrapping my head around looping the column and pasting the name, and the restarting the search. Is this possible? Any help would be appreciated.