Hi! I would like make a button on sheet "summary" that makes a loop through column M on the first sheet and find the first name and check the info in cell -9,11 (relative to the first name). And then go the the last entry in column B. Then I want this info copied to A1:A3 on the sheet "summary". Do this for each first name you find.
If it's easier I can modify the sheet so that the row with the hours also have a name in column M.
See my sheet attached (must work with Excel 2003). I have filled in the desired result.
I hope you can help out.
Bookmarks