Extending existing VBA code

Hi,

I have downloaded an example sheet which demonstrates how a simple form can be created on a spreadsheet to save data to another sheet that acts as a database.

It is perfect for me if a small extension can be* added to it.

I have various classes like Mazdoor, Class I, Class II etc.,. Can I have a drop down box in the first cell which contain all these classes so that I can select a particular class and the data entered is saved to that particular class sheet only.

Any help is greatly appreciated.

Thank you.

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.

Hi
Cell A1 has a dropdown. B2 to F2 is where you enter data. Add more sheets and extend the list in col X (Study Data validation as suggested by RoyUK)
Ravi

Hi Ravi,
Thank you very much. This is exactly what I wanted.

Can you do another small favour.

After entering data from B2 to F2, next "Tab" press can select "Click me to enter data" button and pressing "Space Bar" may do the rest.

Regards,
Jaya Kumar.