I am really in need of help formulating a Macro in excel 2007.
The spreadsheet i am working with calculates the number of times employees within the company receives any sort of recognition. The company i work for has over 1000 employees, so the spreadsheet is long and tedious to maintain. Nevertheless, i am trying to write a macro that can copy cells A:C (name and supervisor) and paste it into another worksheet based on cell AF (which calculates if they have ever gotten any recognition).
Attached is a sample spreadsheet.
Thank you SOO much for your help!!