Sorry to bother you again!
I was wondering if you could help with one last piece of code for this workbook?
Each month, most clients will have all of their stats green for each department. Therefore instead of both users having to go in and fill in each individual department green for that client, I was hoping to create a command button which would populate all of the relevant cells with the letter "G" based upon the options chosen from two drop down lists.
What I would need is:
- When a user selects "Operations" from the first drop down list and selects a client, the command button will input the letter "G" in columns: G, I, K, M, O, Q, and S for that client.
- When a user selects "Client Management" from the first drop down list and selects a client, the command button will input the letter "G" in columns: H, J, L, N, P, R, and T for that client.
I've attached my updated sheet with the first row completed as an example if a user was to select "Operations" and "Apple" then hit the command button.