workbook references
You sure can.. Use a VLOOKUP()
make sure you open the HR workbook and your current workbook in the same
instance of EXCEL, and just follow the definitions.
"Russell Hampton" wrote:
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?
|