I have a list of over 80 staff members in multiple worksheets, in the first worksheet I have placed a letter beside each to denote the department they belong to. I want to create a code that will check the name and apply the letter department code on the other worksheets. Can anyone help me with such a code. Would appreciate it, I am not really a programmer but still need help desperately.
0 · ·