Hello All,

I am new to MS Excel. I have been assigned to learned this tool, and I am using Excel 2007. For days now I have tried few basic tricks in Excel, thanks to this forum. Now I am tasked to create an attendance sheet to track attendance for our company's events. As I was instructed, I need to create an excel file something like this:

Sheet 1 - Would contain a big text box where the employees would input their ID #s.
Sheet 2 - Should be where the inputted ID # would go to; where as Column A is for the ID #, B for the Name, C for the Dept, D for the Managers Name
Sheet 3 - All the master data where I will source my values for Vlookup

Hope you could help me out and sorry for the lengthy description. Thank you very much in advance. Any help would be appreciated.