Autofilling data ,when a particular data is selected from a list (Data Validation)

[sajeevjvarma]

When a particular data is selected from a list ,corresponding values should be filled in adjacent cells.
For example, When Class-I is selected ,different Fees related to that should be filled in adjacent cells.

Example
[TABLE="width: 779"]
<colgroup><col><col><col span="2"><col span="7"></colgroup><tbody>[TR]
[TD]DATE[/TD]
[TD]NAME[/TD]
[TD]CLASS
[/TD]
[TD]AMOUNT[/TD]
[TD]PAID[/TD]
[TD]TB[/TD]
[TD]NB[/TD]
[TD]STAT[/TD]
[TD]PAID[/TD]
[TD]TOTAL[/TD]
[TD]DUE[/TD]
[/TR]
[TR]
[TD="align: right"]27-05-2019[/TD]
[TD]N.MANOJNA[/TD]
[TD]CLASS-V[/TD]
[TD="align: right"]3970.00[/TD]
[TD="align: right"]3970.00[/TD]
[TD="align: right"]2115.00[/TD]
[TD="align: right"]555.00[/TD]
[TD="align: right"]1300.00[/TD]
[TD="align: right"]3970.00[/TD]
[TD="align: right"]3970.00[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]ANSHAR BASHEER[/TD]
[TD]CLASS-V[/TD]
[TD="align: right"]3970.00[/TD]
[TD="align: right"]3970.00[/TD]
[TD="align: right"]2115.00[/TD]
[TD="align: right"]555.00[/TD]
[TD="align: right"]1300.00[/TD]
[TD="align: right"]3970.00[/TD]
[TD="align: right"]3970.00[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]P.DAR****H[/TD]
[TD]CLASS-I[/TD]
[TD="align: right"]3400.00[/TD]
[TD="align: right"]3400.00[/TD]
[TD="align: right"]1775.00[/TD]
[TD="align: right"]525.00[/TD]
[TD="align: right"]1100.00[/TD]
[TD="align: right"]3400.00[/TD]
[TD="align: right"]3400.00[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD]TOTAL[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]11340.00[/TD]
[TD="align: right"]6005.00[/TD]
[TD="align: right"]1635.00[/TD]
[TD="align: right"]3700.00[/TD]
[TD="align: right"]11340.00[/TD]
[TD="align: right"]11340.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]05-06-2019[/TD]
[TD]T.L.LAVANYA[/TD]
[TD]CLASS-VII[/TD]
[TD="align: right"]3730.00[/TD]
[TD="align: right"]3730.00[/TD]
[TD="align: right"]1592.00[/TD]
[TD="align: right"]630.00[/TD]
[TD="align: right"]1500.00[/TD]
[TD="align: right"]3730.00[/TD]
[TD="align: right"]3722.00[/TD]
[TD="align: right"]-8.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]T.MEGHANA[/TD]
[TD]CLASS-V[/TD]
[TD="align: right"]3970.00[/TD]
[TD="align: right"]1270.00[/TD]
[TD="align: right"]2115.00[/TD]
[TD="align: right"]555.00[/TD]
[TD="align: right"]1300.00[/TD]
[TD="align: right"]1270.00[/TD]
[TD="align: right"]3970.00[/TD]
[TD="align: right"]2700.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]5000.00[/TD]
[TD="align: right"]3707.00[/TD]
[TD="align: right"]1185.00[/TD]
[TD="align: right"]2800.00[/TD]
[TD="align: right"]5000.00[/TD]
[TD="align: right"]7692.00[/TD]
[TD="align: right"]2692.00[/TD]
[/TR]
[TR]
[TD="align: right"]06-06-2019[/TD]
[TD]S.S.SIDHARTH[/TD]
[TD]LKG[/TD]
[TD="align: right"]1835.00[/TD]
[TD="align: right"]1835.00[/TD]
[TD="align: right"]1090.00[/TD]
[TD="align: right"]195.00[/TD]
[TD="align: right"]550.00[/TD]
[TD="align: right"]1835.00[/TD]
[TD="align: right"]1835.00[/TD]
[TD="align: right"]0.00
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1835.00[/TD]
[TD="align: right"]1090.00[/TD]
[TD="align: right"]195.00[/TD]
[TD="align: right"]550.00[/TD]
[TD="align: right"]1835.00[/TD]
[TD="align: right"]1835.00[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD="align: right"]07-06-2019[/TD]
[TD]K.RAJESWARI[/TD]
[TD]CLASS-VIII[/TD]
[TD="align: right"]4435.00[/TD]
[TD="align: right"]4435.00[/TD]
[TD="align: right"]1592.00[/TD]
[TD="align: right"]630.00[/TD]
[TD="align: right"]1500.00[/TD]
[TD="align: right"]4435.00[/TD]
[TD="align: right"]3722.00[/TD]
[TD="align: right"]-713.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B.SOWJANYA[/TD]
[TD]CLASS-IX[/TD]
[TD="align: right"]4470.00[/TD]
[TD="align: right"]3000.00[/TD]
[TD="align: right"]2070.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]1600.00[/TD]
[TD="align: right"]3000.00[/TD]
[TD="align: right"]3670.00[/TD]
[TD="align: right"]670.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]K.MANJU[/TD]
[TD]CLASS-II[/TD]
[TD="align: right"]3470.00[/TD]
[TD="align: right"]3470.00[/TD]
[TD="align: right"]1845.00[/TD]
[TD="align: right"]525.00[/TD]
[TD="align: right"]1100.00[/TD]
[TD="align: right"]3470.00[/TD]
[TD="align: right"]3470.00[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]K.VARAPRASAD[/TD]
[TD]CLASS-III[/TD]
[TD="align: right"]3530.00[/TD]
[TD="align: right"]3530.00[/TD]
[TD="align: right"]1905.00[/TD]
[TD="align: right"]525.00[/TD]
[TD="align: right"]1100.00[/TD]
[TD="align: right"]3530.00[/TD]
[TD="align: right"]3530.00[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD]
Data to be filled , when a particular class is selected

[TABLE="width: 320"]
<colgroup><col style="width:48pt" width="64" span="5"> </colgroup><tbody>[TR]
[TD="width: 64"]NURSERY[/TD]
[TD="class: xl67, width: 64, align: right"]1295.00[/TD]
[TD="class: xl65, width: 64, align: right"]610.00[/TD]
[TD="class: xl65, width: 64, align: right"]135.00[/TD]
[TD="class: xl65, width: 64, align: right"]550.00[/TD]
[/TR]
[TR]
[TD]LKG[/TD]
[TD="class: xl67, align: right"]1835.00[/TD]
[TD="class: xl65, align: right"]1090.00[/TD]
[TD="class: xl65, align: right"]195.00[/TD]
[TD="class: xl65, align: right"]550.00[/TD]
[/TR]
[TR]
[TD]UKG[/TD]
[TD="class: xl67, align: right"]2115.00[/TD]
[TD="class: xl65, align: right"]1340.00[/TD]
[TD="class: xl65, align: right"]225.00[/TD]
[TD="class: xl65, align: right"]550.00[/TD]
[/TR]
[TR]
[TD="class: xl66"]CLASS-I[/TD]
[TD="class: xl67, align: right"]3400.00[/TD]
[TD="class: xl65, align: right"]1775.00[/TD]
[TD="class: xl65, align: right"]525.00[/TD]
[TD="class: xl65, align: right"]1100.00[/TD]
[/TR]
[TR]
[TD]CLASS-II[/TD]
[TD="class: xl67, align: right"]3470.00[/TD]
[TD="class: xl65, align: right"]1845.00[/TD]
[TD="class: xl65, align: right"]525.00[/TD]
[TD="class: xl65, align: right"]1100.00[/TD]
[/TR]
[TR]
[TD]CLASS-III[/TD]
[TD="class: xl67, align: right"]3530.00[/TD]
[TD="class: xl65, align: right"]1905.00[/TD]
[TD="class: xl65, align: right"]525.00[/TD]
[TD="class: xl65, align: right"]1100.00[/TD]
[/TR]
[TR]
[TD]CLASS-IV[/TD]
[TD="class: xl67, align: right"]3880.00[/TD]
[TD="class: xl65, align: right"]2025.00[/TD]
[TD="class: xl65, align: right"]555.00[/TD]
[TD="class: xl65, align: right"]1300.00[/TD]
[/TR]
[TR]
[TD]CLASS-V[/TD]
[TD="class: xl67, align: right"]3970.00[/TD]
[TD="class: xl65, align: right"]2115.00[/TD]
[TD="class: xl65, align: right"]555.00[/TD]
[TD="class: xl65, align: right"]1300.00[/TD]
[/TR]
[TR]
[TD]CLASS-VI[/TD]
[TD="class: xl67, align: right"]3550.00[/TD]
[TD="class: xl65, align: right"]1417.00[/TD]
[TD="class: xl65, align: right"]630.00[/TD]
[TD="class: xl65, align: right"]1500.00[/TD]
[/TR]
[TR]
[TD]CLASS-VII[/TD]
[TD="class: xl67, align: right"]3725.00[/TD]
[TD="class: xl65, align: right"]1592.00[/TD]
[TD="class: xl65, align: right"]630.00[/TD]
[TD="class: xl65, align: right"]1500.00[/TD]
[/TR]
[TR]
[TD]CLASS-VIII[/TD]
[TD="class: xl67, align: right"]4335.00[/TD]
[TD="class: xl65, align: right"]2035.00[/TD]
[TD="class: xl65, align: right"]700.00[/TD]
[TD="class: xl65, align: right"]1600.00[/TD]
[/TR]
[TR]
[TD]CLASS-IX[/TD]
[TD="class: xl67, align: right"]4370.00[/TD]
[TD="class: xl65, align: right"]2068.00[/TD]
[TD="class: xl65, align: right"]700.00[/TD]
[TD="class: xl65, align: right"]1600.00[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]14435.00[/TD]
[TD="align: right"]7412.00[/TD]
[TD="align: right"]1680.00[/TD]
[TD="align: right"]5300.00[/TD]
[TD="align: right"]14435.00[/TD]
[TD="align: right"]14392.00[/TD]
[TD="align: right"]-43.00


[/TD]
[/TR]
</tbody>[/TABLE]