CindyKerite
New Member
- Joined
- Sep 12, 2011
- Messages
- 1
I have a excel file with 5 worksheet. The first sheet contains employee names, dept code, date of hire,
Sheets 2 - 5 list the employee name (taken from sheet 1 by: =IF(ISBLANK('All employees'!A1),"",'All employees'!A1) followed by various types of training in the columns.
If I add an employee to the 1st sheet and sort it, the remaining sheets, sort correctly, but the data in the columns remains and now the training dates don't correspond with the employee name.
How can I get the data to sort with the names?
Sheets 2 - 5 list the employee name (taken from sheet 1 by: =IF(ISBLANK('All employees'!A1),"",'All employees'!A1) followed by various types of training in the columns.
If I add an employee to the 1st sheet and sort it, the remaining sheets, sort correctly, but the data in the columns remains and now the training dates don't correspond with the employee name.
How can I get the data to sort with the names?
