Ed, Thanks for the reply. For clarification, I have 4 Worksheets, one for
each of 4 weeks. Each week's worksheet produces a point total for each
person which needs to copy to the overall Ratings Sheet in each of the four
weeks.. i.e. Person "Smith" receives 10 points in Week One. Person
"Jones" receives 12 points in Week One. Both of these totals are sorted in
Week One worksheet, ("Jones" has the highest score) and added to the Week One
Col F in the "Performance Rating" worksheet. Week One is now finished.
Week Two "Smith" receives 14 points, "Jones" receives 9 points. "Smith" has
the highest total for Week Two. These scores are copied to the "Performance
Ratings" sheet under Col G. The two scores are summed and "Smith has 24
points and "Jones" has 21 points total. Each Week worksheet is sorted as
well as the overal "Performance Ratings" sheet. Weeks Three and Four are the
same as the above. I am doing this manually now. Would just like to have a
means to automate the process.

I thought a VBA code might be the answer.

Bob



"Ed Ferrero" wrote:

Hi robert morris,

Not too clear on what you are trying to do, but have you tried VLOOKUP ?

See my Excel Database tutorial at
http://www.edferrero.com/ExcelTutori...0/Default.aspx
for some ideas on how to set up this type of workbook.

Ed Ferrero
www.edferrero.com