Need hyperlink to move to another worksheet with rest of the row

Hi guys,

I am wondering if someone could help with this..

I have a VBA which moves a row from the outstanding work sheet to a completed work sheet when the status in column J is changed to 'Complete'. In column A is the Job name which I have set as a hyperlink to a individual folder for that project.

My problem is that when the job is complete and it moves to another worksheet, it does not carry the hyperlink with it.

Anybody know of a way to do this??

I have attached the file for reference.

Thanks

Dan

Hi DJ_Rutts

I've used this code with mixed success...you may wish to play with it

Please Login or Register  to view this content.