A colleague of mine was sent a spreadsheet that had a number of dropdown
lists. One of the dropdowns had lost its data. My colleague asked me if I
could fix it for him rather than sending it back to the person that created
it because of the turn-around time. I ended up having to cheat and create a
new data list because I couldnt find the original data source. I checked for
hidden sheets, I checked for white text and I checked Visual Basic, but to no
avail. Could someone tell me how I can find the data source.

Thanks in advance

Lynda