Each day I produce a list of names, varying in length from approx. 400 to 800 names. The list changes daily with no two days ever the same. (Racing application – list of daily contestants)

On ten separate Excel worksheets I analyse ten different sets of data to try and produce a numerical rating figure for each contestant (to one decimal place) - call them factors one to ten. My available data is never complete so each of the ten factor lists is never a complete match for the master list.

I now combine all the factor lists into one long secondary list – Name, Rating, Factor ID – and am looking for a macro to update the master list from the secondary list. The master list would comprise the contestant names with factors one to ten in adjacent columns. It doesn’t matter where I place my secondary list – same or different worksheet relative to master list – which ever is easiest. (Or even update the master list from the ten individual factor lists if this is necessary)

Thanks in advance for any help – greatly appreciated.

(I am exporting all the raw data from an Access db into Excel because the analysis is simply too complex for my basic Access programming skills. This is only a new project so I am looking for ways to simplify as much of the process as possible.)

Barry