I am having trouble getting the drop downs that are dependent on the previous drop-dwon selection to work correctly. I got it to work in a plain excel worksheet, but now im tryign to copy, or add it into an existing worksheet with other data. The firdst title is theme, and the second is category. keeps giving me an error. thanks