There is another problem which I want to tackle.
I want that students's data be entered in only Main sheet and then it
should automatically be pasted in subject sheets (in subjects which are
in blue columns in Main for each student). Students' data should be
pasted in subject sheets in last empty row.
e.g if a student choses 1.1, 1.2 and 1.3 then it should automatically
be pasted in sheets 1.1, 1.2 and sheet 1.3 in last empty row.

is there any way?

Regards


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=551813