Copy hyperlink from one sheet to another

%3CLINGO-SUB%20id%3D%22lingo-sub-2182009%22%20slang%3D%22en-US%22%3ECopy%20hyperlink%20from%20one%20sheet%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2182009%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%20see%20attachment.%3C%2FP%3E%3CP%3EI%20have%20two%20tables%20one%20which%20is%20active%20projects%20and%20one%20which%20is%20completed%20projects.%3C%2FP%3E%3CP%3EI%20have%20a%20macro%20written%20to%20move%20projects%20marked%20F%20(finished)%20from%20active%20to%20completed.%3C%2FP%3E%3CP%3EI%20have%20now%20added%20two%20columns%20with%20hyperlinks%20and%20I%20need%20to%20edit%20the%20macro%20to%20copy%20and%20maintain%20the%20hyperlinks%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20any%20and%20all%20help%3C%2FP%3E%3CP%3EChris%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2182009%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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

0 Replies