Performance Ratings VBA help

[robert morris]

I have five Worksheets in a Workbook Four of them have the same formats and
are titled Week One, Week Two, Week Three and Week Four. Each of these four
have 30 Rows. The other is Titled "Performance Ratings" which also has the
30 rows, but with a different format. I need a VBA to connect the person's
"Name" Col E10:E40 in Worksheet Week One to the "Performance Ratings",
Worksheet Col C8:C38. W/S Week One is then sorted.

W/S Week Two only changes the Performance Points from C10:C40 to
"Performance Ratings" sheet Col G8:G38. Again this is sorted and the
accumulated points in the "Performance Ratings" is also sorted.

W/S's Week Three and Week Four are as above with the Performance Points
going to Col H8:H38 and Col I8:I38 respectively.

Again, after each of the 4 W/S's having been sorted, I need to sort the
"Performance Ratings" sheet.

Does anyone have a quick VBA for this? I have tried to link the four W/S's
to the Ratings Sheet but have failed. Maintaining the integrity of the names
with the scores after sorting is paramount.

Bob

 

[Ed Ferrero]

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/ExcelTutorials/ExcelDatabaseTutorialPart1/tabid/90/Default.aspx
for some ideas on how to set up this type of workbook.

Ed Ferrero
www.edferrero.com

 

[robert morris]

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