<div>
thanks!!!! &nbsp;This is what i was needing. &nbsp;have used VLOOKUP between sheets in a workbook but never between workbooks. &nbsp;Have a great day!!!
</div>


thanks!!!!  This is what i was needing.  have used VLOOKUP between sheets in a workbook but never between workbooks.  Have a great day!!!

<div>
<div class="content wysiwyg-content">
i have a Excel list of department numbers and their associated supervisors. &nbsp;I also have an excel spreadsheet that contains employee names and the department they worked in each day. &nbsp;I need to be able to open the sheet with the employee names and the department they worked in and have the supervisor name added to each line, for each employee. &nbsp;How do i do this?????
</div>
</div>


i have a Excel list of department numbers and their associated supervisors.  I also have an excel spreadsheet that contains employee names and the department they worked in each day.  I need to be able to open the sheet with the employee names and the department they worked in and have the supervisor name added to each line, for each employee.  How do i do this?????

Excel 2007 Macro

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.