I want to create a data validation, with a dropdown list, using initially 3 cell ranges. I couldn't work out how to do it, so I created another range including 3 separate areas on my first worksheet called "dropdown". Can someone please help. What do I type into the data verification box (2nd sheet - E4), so it will show the cells relating to "Dropdown" or "COS" & "Expenses" & "Capital". File attached. Many thanks.