Hi All,
I have to extract some data's from large number of Dump data with multiple filtering.Which should to shown in summary sheet while updating the dump data for next frequency.Here below a sample data.
Summary sheet :
--------------------
[TABLE="width: 500"]
[TR]
[TD][/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="width: 64"]July[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="width: 64"]Aug[/TD]
[/TR]
[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 209"]
[TR]
[TD="class: xl65, width: 209"]Total Marks by 1 standard [/TD]
[/TR]
[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 209"]
[TR]
[TD="class: xl65, width: 209"]Total Marks by 3 standard [/TD]
[/TR]
[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 209"]
[TR]
[TD="class: xl65, width: 209"]Total Marks by 4 standard[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 209"]
[TR]
[TD="class: xl65, width: 209"]Total Marks by 5 standard [/TD]
[/TR]
[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 209"]
[TR]
[TD="class: xl65, width: 209"]No of students in 1 Standard[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 209"]
[TR]
[TD="class: xl65, width: 209"]No of students in 2 Standard[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 209"]
[TR]
[TD="class: xl65, width: 209"]No of students in 3 Standard[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 209"]
[TR]
[TD="class: xl65, width: 209"]No of students in 5 Standard[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 209"]
[TR]
[TD="class: xl65, width: 209"]Total No students in English[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 209"]
[TR]
[TD="class: xl65, width: 209"]Total No students in Hindi[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 209"]
[TR]
[TD="class: xl65, width: 209"]Total No students in Tamil[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[/TABLE]
Dump data in another sheet same workbook:
--------------------------------------------------
[TABLE="width: 500"]
[TR]
[TD][TABLE="width: 34"]
[TR]
[TD="class: xl65, width: 34"]S.no[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]Name[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]Month[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]Standard[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]Subject[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]Marks[/TD]
[/TR]
[/TABLE]
[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]Ram[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]July[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]1[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]English[/TD]
[/TR]
[/TABLE]
[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]gokul[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]Aug[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]1[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]English[/TD]
[/TR]
[/TABLE]
[/TD]
[TD]24[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]Kannan[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]Aug[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]3[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]Hindi[/TD]
[/TR]
[/TABLE]
[/TD]
[TD]65[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]vishnu[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]July[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]4[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]Tamil[/TD]
[/TR]
[/TABLE]
[/TD]
[TD]70[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]Hari[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]July[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]5[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]Hindi[/TD]
[/TR]
[/TABLE]
[/TD]
[TD]85[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]Ramesh[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]Aug[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]4[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]English[/TD]
[/TR]
[/TABLE]
[/TD]
[TD]58[/TD]
[/TR]
[/TABLE]
Thanks in advance.....
I have to extract some data's from large number of Dump data with multiple filtering.Which should to shown in summary sheet while updating the dump data for next frequency.Here below a sample data.
Summary sheet :
--------------------
[TABLE="width: 500"]
[TR]
[TD][/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="width: 64"]July[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="width: 64"]Aug[/TD]
[/TR]
[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 209"]
[TR]
[TD="class: xl65, width: 209"]Total Marks by 1 standard [/TD]
[/TR]
[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 209"]
[TR]
[TD="class: xl65, width: 209"]Total Marks by 3 standard [/TD]
[/TR]
[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 209"]
[TR]
[TD="class: xl65, width: 209"]Total Marks by 4 standard[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 209"]
[TR]
[TD="class: xl65, width: 209"]Total Marks by 5 standard [/TD]
[/TR]
[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 209"]
[TR]
[TD="class: xl65, width: 209"]No of students in 1 Standard[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 209"]
[TR]
[TD="class: xl65, width: 209"]No of students in 2 Standard[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 209"]
[TR]
[TD="class: xl65, width: 209"]No of students in 3 Standard[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 209"]
[TR]
[TD="class: xl65, width: 209"]No of students in 5 Standard[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 209"]
[TR]
[TD="class: xl65, width: 209"]Total No students in English[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 209"]
[TR]
[TD="class: xl65, width: 209"]Total No students in Hindi[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 209"]
[TR]
[TD="class: xl65, width: 209"]Total No students in Tamil[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[/TABLE]
Dump data in another sheet same workbook:
--------------------------------------------------
[TABLE="width: 500"]
[TR]
[TD][TABLE="width: 34"]
[TR]
[TD="class: xl65, width: 34"]S.no[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]Name[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]Month[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]Standard[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]Subject[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]Marks[/TD]
[/TR]
[/TABLE]
[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]Ram[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]July[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]1[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]English[/TD]
[/TR]
[/TABLE]
[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]gokul[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]Aug[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]1[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]English[/TD]
[/TR]
[/TABLE]
[/TD]
[TD]24[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]Kannan[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]Aug[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]3[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]Hindi[/TD]
[/TR]
[/TABLE]
[/TD]
[TD]65[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]vishnu[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]July[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]4[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]Tamil[/TD]
[/TR]
[/TABLE]
[/TD]
[TD]70[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]Hari[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]July[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]5[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]Hindi[/TD]
[/TR]
[/TABLE]
[/TD]
[TD]85[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]Ramesh[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]Aug[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]4[/TD]
[/TR]
[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
[TR]
[TD="class: xl65, width: 64"]English[/TD]
[/TR]
[/TABLE]
[/TD]
[TD]58[/TD]
[/TR]
[/TABLE]
Thanks in advance.....