how update one cell based on another cells data
Guys,
What I am trying to do is basd on the following column setup:
A B C D E
Supervisor Agent Month Score Quarter
John Doe Jane Smith September 96 3
John Doe Jane Smith December 99 4
I want to simply choose the month from from a list and have the Quarter
Column automatically choose the correct quarter.
|