Copy hyperlink from one sheet to another

Please see attachment.

I have two tables one which is active projects and one which is completed projects.

I have a macro written to move projects marked F (finished) from active to completed.

I have now added two columns with hyperlinks and I need to edit the macro to copy and maintain the hyperlinks 

Thanks in advance for any and all help

Chris