Copy a cell with hyperlink

Hello
There's a small issue with the "BASE" sheet (unable to access it via VBA). I renamed it to "BASEold" and created another one that works fine.
I added a button "Copy Hyperlink", you just need to click on it for the links to be copied to the "MDR" sheet with formulas included.

https://www.cjoint.com/c/EBykUlhbUL2
Hoping this works for you.
Best regards

Hello
Not having much precision regarding the copying (which cell, sheet name, etc.), here is what it looks like using the macro recorder
example: copying a cell with a hyperlink from cell A1 of sheet 1 to cell B1 of sheet 2

 Sheets("Sheet1").Select '
 Range("A1").Select
 Selection.Copy
 Sheets("Sheet2").Select
 Range("B1").Select
 Selection.PasteSpecial Paste:=xlPasteAllUsingSourceTheme, Operation:=xlNone , SkipBlanks:=False, Transpose:=False

which is the same as doing it manually
cell A1 sheet 1: select - copy
cell B1 sheet 2: paste special - All, with source theme
Hoping this may help you
Best regards