I am brand new with macros, so I am not entirely sure how to run this.

I selected macros on the upper left, then created the macro by copying and pasting your code. Since the zip codes are in column D, I changed A to D instead. After I save the macro file, I am not too sure how to run and test it.

I would ultimately want the zip codes inputted to a brand new column on the right.