I have a list of names in Column B which has the possibility of changing order if the list gets a new name based on meeting a criteria. These list of names are used to determine who has achieved an award. I need a way of keeping track of when an award was given to this individual. Because the list has the possibility of "growing" in size or names changing order I can't just highlight the cell with the name in it because the name may then be in another cell the next time. So is true if I add a column of dates next to the name.
Anyone have a method of keeping track which name has received an award? I was thinking I could create another list of names from the list that changes and grows but I'm not sure how to create a list of names and all new names are added to the bottom of the list. Any ideas?
<tbody>
</tbody>
Any ideas or help would be appreciated
Anyone have a method of keeping track which name has received an award? I was thinking I could create another list of names from the list that changes and grows but I'm not sure how to create a list of names and all new names are added to the bottom of the list. Any ideas?
| Names | Names (next time I open excel) |
| name1 | newname |
| name2 | name1 |
| name3 | name2 |
| name4 | name3 |
| name4 |
<tbody>
</tbody>
Any ideas or help would be appreciated
