Is it possible to merge data from an excel spreadsheet such as employee names and merge them in to another spread sheet such as an employee time sheet that is in excel. I would like it to work like mail merge with Word only from Excel to excel.
LOOKUP tables might bring the data in for you. Probably a vertical lookup VLOOKUP where your employee name spreadsheet is your lookup range and has to be displayed alpabetically. I am not a lookup expert by anymeans but have used them sucessfully for many simple "merges" in excel. Check the help files in excel on them and if you want to explore it more, email me. I'll help the best that I can.