Hi there,
I am working on a department tracker that allows the user to select the departments in the store by using the letter "y" in column C in the 'Codes' sheet. All departments that are selected with a Y then remains visible on the 'training' sheet. All other departments that are not selected with a "Y" will remain blank and hidden on the 'Training' sheet.
The code would need to identify the line based on the Dept code displayed in each of the sheets(example 015a)
I have found a piece of code that I have been trying to adapt to fit my sheet however as i have little experience in VBA i am finding it difficult.
Please see code below
If anyone could help it would be greatly appeciated.
Thanks
Justin
Bookmarks