I am creating a sheet to be used by our staff for vacation requests. I am
using drop down lists for them to choose name and department. I would like to
bring over information from another workbook that HR uses to compile time
available to each staff member to take off. I can reference individual cells
of course but I don't want to have a different sheet for each employee. Is
there anyway to make the reference dependent upon a variable? So if the
employee is me the reference will look for my name? I guess I looking for
something like IF THEN. Any ideas?