Adding names of users from one column to another and color change to annual cap
I have attached a sample file of what I'm trying to accomplish and hope that you can assist. I'm using Excel 2016 and have multiple tabs indicating each month.
In the Apr 17 tab, I need the users name in Column B to also appear in Column P for each instrument used.
Also, in the Q1 tab, I'd like to list the number of users in Column C and the initials of the users in Column D.
There is a cap to the amount folks will be charged for use so I need the color to change once the user has reached the annual cap amount.
What is the best way to do these tasks?
Thank you.
|