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:

Number	Name	Card Type	Attribute	Type	Level	Atk	Def
DREV-EN005	A/D Changer	Effect Monster	Light	Warrior	1	100	100
DP10-EN010	A/D Changer	Effect Monster	Light	Warrior		100	100
BPW2-EN032	A/D Changer
CDIP-EN013	Abaki	Effect Monster	Fire	Fiend	4	1700	1100
YSDS-EN020	Abaki	Effect Monster	Fire	Fiend		1700	1100

<TBODY>
</TBODY>

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.

AST-072	Absorbing Kid from the Sky	Effect Monster	Light	Fairy	4	1300	1000
ABYR-EN085	Abyss Dweller
CMC-EN001	Abyss Soldier	Effect Monster	Water	Aqua	4	1800	1300
CP02-EN007	Abyss Soldier	Effect Monster	Water	Aqua		1800	1300

<TBODY>
</TBODY>

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.