Lists and Macros

Hey everyone, I'm new here... I'm finishing up a project for the start of my new business and I need some of your help.

I have a spreadsheet that contains 22 rows for employees and 15 columns. Each day an employee makes a certain amount of money and that's the data i need to enter in the row on the necessary day (column). Is it possible to make a list that correlates with the list of names I have for the employees (included if I add a new one too) in where as if i decide to fire somebody I can click a button so it can turn the row a light red color and state the date the employee left (the same day i click the button).

My only problem here is when I record a macro, It only does it for one individual row and I have another 21 rows. Plus I might even add more employees!!

Help!! How do i carry over a simple macro from one button to the next and the next (but the next button correlates it's row)

help!