Talonspell
New Member
- Joined
- Aug 30, 2014
- Messages
- 2
Greetings!
I need some help here with a problem I have. Any help would be much appreciated!
I have the following table in Sheet 1. This is the master list. The Name is the unique identifier.
<tbody>
</tbody>
I have another table in Sheet 2. It is essentially the same thing, except that the names are now in a random order, and the moods of some of the people have changed.
<tbody>
</tbody>
So basically, what I need help with, is a macro that would look at the list of people and their moods in Sheet 2, compare it with the list in Sheet 1, and if there is a change in moods, that particular person in Sheet 1 will be highlighted. That is the first macro I need help with.
The second macro is I need help with is similar to the one above, except that rather than just highlighting the person with the change in mood, I need it to take the mood change in Sheet 2, and update it accordingly to the corresponding person in Sheet 1.
Thanks in advance!
P.S I am using Excel 2010.
I need some help here with a problem I have. Any help would be much appreciated!
I have the following table in Sheet 1. This is the master list. The Name is the unique identifier.
Name | Mood |
John | Happy |
Betty | Sad |
James | Angry |
Peter | Angry |
Carl | Sad |
<tbody>
</tbody>
I have another table in Sheet 2. It is essentially the same thing, except that the names are now in a random order, and the moods of some of the people have changed.
Name | Mood |
Betty | Angry |
Peter | Happy |
John | Happy |
Carl | Sad |
James | Sad |
<tbody>
</tbody>
So basically, what I need help with, is a macro that would look at the list of people and their moods in Sheet 2, compare it with the list in Sheet 1, and if there is a change in moods, that particular person in Sheet 1 will be highlighted. That is the first macro I need help with.
The second macro is I need help with is similar to the one above, except that rather than just highlighting the person with the change in mood, I need it to take the mood change in Sheet 2, and update it accordingly to the corresponding person in Sheet 1.
Thanks in advance!
P.S I am using Excel 2010.
Last edited: