 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
It's 20 years since I last had to use Excel properly and it's moved on faster than I have 🤦♂️
Need to produce a spreadsheet for the team to request leave over the Easter school holiday period. Basically dates across the top, names down the side, then I want each cell to offer "working", "annual leave" and "non working day" options in a dropdown.
I'm not even sure what that function is called, and a hunt round the Office365 help areas doesn't obviously produce it either, so I thought I'd ask here.
Normally these spreadsheets are produced by the business planners, my mistake was asking where the Easter one was and being set a "development opportunity" by the boss
I've not used them myself but this looks like it's what you want
You need to look go to the Data tab and poke around in "Data Validation" options. You can set a cell to only be populated by specific values selected from a drop down menu. The options are typically listed on another sheet.
Superb, found it now
Thanks guys
Excel, the accounting persons hammer! 🙂