I have an issue that I am hoping one of you can come up with a solution.
I have a confidential HR register, I would like to link Sheet A to it just extracting names and department, that will update as staff leave and join. are there any ideas ( My Manager for obvious reasons doesn't want anyone but himself accessing that register - so need away to extract info ( cant use a report as the sheet A needs to be able to link to another sheet for drop downs
Help Article Resources
Check out the Formula Handbook template!