Hi guys i was wondering why the cell which i copied loses the source formatting when i copy and paste link from another worksheet labelled as counter , i've tried clicking keep source formatting and its still doesn't work to no avail . Thanks for the help .