Custom Autofill Data Macro?

[chade]

I have been trying to find a macro or function that will update my worksheet.

I want to autofill data into new records from existing records of the same name. I also want to copy the hyperlink from the top cell of a given Name to the new Number cell of that name.
Here is an example of my workbook:

[TABLE="class: outer_border, width: 700, align: left"]
<TBODY>[TR]
[TD]Number
[/TD]
[TD]Name
[/TD]
[TD]Card Type
[/TD]
[TD]Attribute
[/TD]
[TD]Type
[/TD]
[TD]Level
[/TD]
[TD]Atk
[/TD]
[TD]Def
[/TD]
[/TR]
[TR]
[TD]DREV-EN005
[/TD]
[TD]A/D Changer
[/TD]
[TD]Effect Monster
[/TD]
[TD]Light
[/TD]
[TD]Warrior
[/TD]
[TD]1
[/TD]
[TD]100
[/TD]
[TD]100
[/TD]
[/TR]
[TR]
[TD]DP10-EN010
[/TD]
[TD]A/D Changer
[/TD]
[TD]Effect Monster
[/TD]
[TD]Light
[/TD]
[TD]Warrior
[/TD]
[TD][/TD]
[TD]100
[/TD]
[TD]100
[/TD]
[/TR]
[TR]
[TD]BPW2-EN032
[/TD]
[TD]A/D Changer
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CDIP-EN013
[/TD]
[TD]Abaki
[/TD]
[TD]Effect Monster
[/TD]
[TD]Fire
[/TD]
[TD]Fiend
[/TD]
[TD]4
[/TD]
[TD]1700
[/TD]
[TD]1100
[/TD]
[/TR]
[TR]
[TD]YSDS-EN020
[/TD]
[TD]Abaki
[/TD]
[TD]Effect Monster
[/TD]
[TD]Fire
[/TD]
[TD]Fiend
[/TD]
[TD][/TD]
[TD]1700
[/TD]
[TD]1100
[/TD]
[/TR]
</TBODY>[/TABLE]


In this range, I want to copy the data from cells C3:H3 into C4:H4 as well as copy the hyperlink from cell B2 to cell A4.


This sheet also has new records that do not match existing ones, so I do not want those filled at all.

[TABLE="class: outer_border, width: 700, align: left"]
<TBODY>[TR]
[TD]AST-072
[/TD]
[TD]Absorbing Kid from the Sky
[/TD]
[TD]Effect Monster
[/TD]
[TD]Light
[/TD]
[TD]Fairy
[/TD]
[TD]4
[/TD]
[TD]1300
[/TD]
[TD]1000
[/TD]
[/TR]
[TR]
[TD]ABYR-EN085
[/TD]
[TD]Abyss Dweller
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CMC-EN001
[/TD]
[TD]Abyss Soldier
[/TD]
[TD]Effect Monster
[/TD]
[TD]Water
[/TD]
[TD]Aqua
[/TD]
[TD]4
[/TD]
[TD]1800
[/TD]
[TD]1300
[/TD]
[/TR]
[TR]
[TD]CP02-EN007
[/TD]
[TD]Abyss Soldier
[/TD]
[TD]Effect Monster
[/TD]
[TD]Water
[/TD]
[TD]Aqua
[/TD]
[TD][/TD]
[TD]1800
[/TD]
[TD]1300
[/TD]
[/TR]
</TBODY>[/TABLE]


I know this probably seems over-complicated and unorthodox, but I could really use some assistance as my entire database has around 13,000 records, and I just don't have the time to go through it one by one.

I am not familiar with VBA and my attempts thus far to modify existing macros has not succeeded in any way.

Any help would be greatly appreciated.