Hi everyone,
I'm sort of an excel novice, so I'm hoping someone here will be able to help.
In my excel workbook, columns A and B are used for text (Last and First names, respectively, manually entered by various users at any time of day)
Column C contains a data validation drop-down list with two options ("Student" and "Staff")
For confidentiality purposes, any time a staff name appears in A and B, I have to change it to something arbitrary ("Staff member")
For staff entries like this, column C will read "Staff"
I am currently checking entries multiple times each day so that I can catch staff entries and change them to maintain confidentiality.
Is there ANY way that I could automate this process? I would like to maybe run something that will catch the "Staff" data validation selection in column C, then automatically change the text in columns A and B. For example, if A = "Jones" and B = "George", as soon as "Staff" is selected from the dropdown in C, I'd like A = "Staff member" and B = "Staff member"
A couple of notes:
1. I need this to run automatically for each new entry
2. I need columns A, B, and C to all maintain text, NOT formulas
Bookmarks