HI i have one shhet from my HR company and on another sheet i have exported all the information from AD 2003.
Shhet two with the AD information has a lot more names this is becaue of admin acounts and accounts with users who no longer work for the company but have not been removed from AD. Is there a formual in Excel 2007 where i can match the names in sheet 1 which has the HR names and sheet 2 where i have all the information from AD.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.