I am a novice at excel so please excuse this if this is a basic question. I need to create a list with our unit numbers that will depopulate and repopulate depending if they are entered else where in the same worksheet. We would use it to see which units are at our yard/location( in the list) or at job sites(entered in other columns). It would be really nice for it to be visible all the time. Thanks!!

Matt