How enter data in multiple rows of excel, by calling them from VBA Macro?

Hi,

I have a excel database, which contains different classes e.g. Class-1, Class-2 and Class-3 and every class has 10 different names. Now I want to create three macros by the name Class-1, Class-2 and Class-3, so that if anybody in that excel sheet writes =class-1, then the names which are linked with class-1, shall displayed in excel rows. Simillary on the same sheet other classes may also be called, when required.

If anybody can solve this, it would be a great help.

BR
Deepak