Look Up Values with 7000+ data points

I pull a list of bonds daily and I have a formula that calculates a score. I then need to input those the scores into a database on another sheet that already has existing bonds names and scores. The daily data pull consists of new bonds and also existing bonds that are in my database. I am trying to have new bonds be added to the database with score and name while existing bonds just have the score copied into the correct row and column (by bond name and date).

I tried using a nested for loop where I take one bond name from the new list and compare it to each bond name on the old list but with 7000+ bond names daily, the VBA program takes too long.

Is there anyway to use an existing Excel function with VBA to make this process faster and more efficient?

NewData is the sheet that contains the daily pulled information.

I want to take cell B4 in NewData and add it to cell G3 in the Database sheet. Column G would represent today's bond scores.

The Database sheet will keep a historic record of bond scores that are pulled daily.

Originally Posted by PCI

Is that means that columns C, D, E ,F in sheet "NewData" have already data ?
It means the last column of sheet "Database" must be copid to the last column of sheet "Newdata" ?

Columns C, D, E, F will never have data. The daily pull only generates the name of the bond of the score.

A slightly different approach. Assuming that you wish to add new data to the next empty column the macro will find the first empty column in the "Database" sheet and copy the data from the "NewData" to that empty column.

To test run macr "Adder" from the "Database" sheet.

Alf