Update data from different workbook on demand

[RickeyS]

I have a workbook that I keep track of hours worked for employees, it is laid out employee name, total hrs, and columns for hrs worked each day.

In a different workbook I want to be able to have a formula or a way to lookup and match all the employees and import the total hrs from the first workbook.

How would I start something like this?

Thanks
Rick

 

[RickeyS]

Okay, I got the Vlookup to work, and update the info when I open the workbook, but If I choose not to update the info when opening the workbook how do I update it manually when I want to? I figure I will need a macro to do it but I can't figure how to do it to be able to record a macro. Anyone?

Thanks
Rick