locker

Hi, I've been tasked with creating a master worksheet for locker allocation across the floor. In that worksheet I need the locker number and name of the employee. Each team has it's own worksheet/tab. All the worksheets use the same template and the locker numbers are unique across the...

Hi all, hope you can help... I have a cell that has a list of locations to select from. Once selected, in the cell next to it i need for it to again have a drop down list of equipment that is in the location selected. I have created tables with these lists in already in a different sheet. i've...

Morning, here's something for you. I wasn't able to find solution to my question anywhere. However if this topic has appeared somewhere here already, please let me know where I can find my answers. I've got 2 Excel sheets with linked information on both tabs. First one is a table containing a...

Hi, Can password lock everything in sheet including the view tab....As i dont want the user to be able to unfreeze(which is now working), + i dont want them to be able to click on formula bar check box and headings... Is there a way to achieve this as normally it cant be? Thanks for suggesting...