Required some changes in excel formula.

[prince]

Hello Sir/Madam, I have prepared a seating plan for 12 students in each room. But in Tab 3 (seating plan) column B7-B10 formula, not applying. It starts working from Column C7-C10. Kindly sort out this problem.
Thanks & Regards
Prince

[HansV]

Change the formula in B7 to

=IF(INDEX('Roll-No'!$A$1:$A$2001,12*INT(ROW()/12)+MOD(ROW()-7,4)+4*COLUMN()-6)="","--",INDEX('Roll-No'!$A$1:$A$2001,12*INT(ROW()/12)+MOD(ROW()-7,4)+4*COLUMN()-6))

Fill to the right, then down (or vice versa).

[prince]

Thank you sir so much for this support. Really I am grateful for this help.
With regards,
Prince