Basically i am redoing an Excel file i use to record the Annual leave, for something else, Each cell has a pulldown box of codes, you can only enter a code from the list, I need to change these codes, but i cant find the list of codes, it must be inbedded somewhere, anyone ever done an Excell sheet like this?
There is a worksheet called codes, but all this is a list with no formuals attached etc and adding to this list has no effect on the drop down box


me confused