Filtering a large range of data to return only row title and cell value

Hi,

I have a database of scores that runs for approximately 2000 rows and 600 columns. In column A, I have all the names of each item in the database (in this case it is a stock code). In row 4 I have a score change column identifier which is just a count going outwards.

This database is updated weekly. I have my current spreadsheet set up to copy the old database to a sheet called "Database Old" then import the new database to a sheet called "Database". These two sheets are then compared on a third sheet called "Score Changes". If a score changes then the corresponding cell in the "Score Changes" sheet will return a value, if the score has not changes it will return "".

What I want to do with the next step is take this "score change" sheet and either through formulas or VBA search through the entire data set and where a score has changed pull out to a new sheet the stock code (from col A) and the number being returned in the cell where the stock change has occurred next to it.

I am cognisant that the above explanation may be confusing so I have attached an extract of the problem. In the attached I have put a small exert of the full "Score Changes" tab. In addition I have added a sheet called "output" which is what I would like the vba code or formulas to return.

Thanks in Advance

Hi FDibbins,

Thanks for the response.

I think I stripped too much out of the attachment that I previously sent, so apologies for that. However you have understood the basic premise of what I am after.

Attached is a more detailed spreadsheet that should hopefully articulate more accurately what I am trying to do.

As you mentioned there are 2 sheets ("Database" & "Database Old") that I am comparing and searching for differences. The "Score Changes" sheet then compares these two sheet and identifies where a score has been changed. Take cell E17 in the "Score Change" sheet as an example. This score has been identified as changing and as result cell E17 returns the index number 2 from the Score Changes Col in row 4. The reason for this is this is that it is then used on the output sheet to pull additional data.

The next step is where I am stuck which is I want a method of searching through the entire "Score Changes" sheet and extracting the stock code and the score changes col for each score change as per the green cells on the "Output" tab in the range A5 - B10. You will then see in the red cells in range D5 - G10 why I need the score changes col to be pulled through as this is then used in the index functions to give me the required data I need for each score change.

Hopefully that makes sense

Thanks