Copy Static Hyperlinks from one Worksheet to another without disturbing Target Range Format

[sspatriots]

Good evening,

I'm trying to generate code that will copy the static hyperlinks from column 'X' on a worksheet (starting in cell X2) called "Drops" and then overwrite the same list of numbers that are in a table column called "PO#" on a worksheet called "2024". The table name on the destination worksheet is "Table4711". I think I can figure this out easy enough if it weren't for having to maintaining the current formatting in the column on the destination worksheet. Hopefully I've provided enough information here, if not I apologize. Thanks, SS

--------------------

Source Worksheet "Drops"---------------------Destination Worksheet "2024"

 

[sspatriots]

After pondering over this overnight, I came up with a workaround. This may or may not be useful to others, but wanted to share my logic I used as the workaround. Since I could not figure out a way to copy the static hyperlinks directly without disturbing the destination formatting, I ended up copying the destination range "formats only" over the source range and then copied the source range and pasted it in its entirety back over the destination range. I hope that makes sense. I'm sure there is a cleaner way to do this, but this did work for me. If anyone has any different ideas I'm still open to hear them. Thanks, Steve