It has been too many years since I did any programming and never learned VBA and not interested in learning now.

I have a list approximately 850 to 900 items long and need to copy the hyperlink in column C and use the same to create a hyperlink in column A, same row. I am thinking While-Wend would be the way to go in order to stop the macro if the active cell in column C is empty. I have already done a few rows with dead links and deleted the contents of column C at those rows. To give an example of what I'm working on here is a two row list:

A (needs a hyperlink) B C (with hyperlink or deleted)
Freewheeler Rig, by Bob McLellon – Date: 9/10/03 Freewheeler Rig by Bob McLellon – Date: 9/10/03
Freewheeling Ideas, by Nason – Date: 9/10/06

The purpose of what I'm working on, if it isn't obvious, is to separate the date from the title.