Hi Roy,

Thanks for your. It only teaches how to create a drop down box. Now I have created a drop down list which contains names of sheets in my work book. If click on a sheet's name, the data which I entered requires to be saved in the corresponding sheet.

Can you give me a macro for this.

Thank you.