Sorry Barry,
The info i gave you in the first post was incomplete.
If you could help me amend the code to include the following that would be great?

needed the code to:-
If the department is selected "y" in the 'codes' sheet then the line remains visible in the 'Training' sheet. all other lines without a "Y" need to be hidden on the 'Training' sheet.
Also I need to the rows to be hidden based on the dept code not the row it sit on.


Thanks

Justin.