BravoBravoAu
Board Regular
- Joined
- Nov 8, 2011
- Messages
- 63
- Office Version
- 2016
- Platform
- Windows
Dear Excel geniuses, I hope this is another easy solution.
I have two worksheets:
1. Worksheet 1 contains all details about employees including personal information. Column L is whether the employee is 'active' with a YES/NO list.
2. Worksheet 2 contains a phone list that is widely available and can't include personal information. For active employees (eg those who have YES in Worksheet1, column L), I would like SOME details copied into Worksheet 2.
When employees are changed to inactive (eg those who have NO in Worksheet1, column L), I'm looking for them to 'disappear' from Worksheet2 and the results adjust so there are no row spaces. Worksheet1 wont have information removed.
I hope this helps.
Worksheet2
I have two worksheets:
1. Worksheet 1 contains all details about employees including personal information. Column L is whether the employee is 'active' with a YES/NO list.
2. Worksheet 2 contains a phone list that is widely available and can't include personal information. For active employees (eg those who have YES in Worksheet1, column L), I would like SOME details copied into Worksheet 2.
When employees are changed to inactive (eg those who have NO in Worksheet1, column L), I'm looking for them to 'disappear' from Worksheet2 and the results adjust so there are no row spaces. Worksheet1 wont have information removed.
I hope this helps.
Worksheet2
A | B | C | D | |
1 | Employee Name | Employee Number | Phone Number | Desk |
2 | (Copied data from Worksheet1, column A) | (Copied data from Worksheet1, column B) | (Copied data from Worksheet1, column G) | (Copied data from Worksheet1, column E) |
3 |