Hi,
I am new to VBA and i have been trying to achieve the following but i am stuck. I have different tables in one worksheet with common headers from which i need to collate the data into a single table with one set of headers, in a different worksheet. Example given below is of the Raw data sheet.
[TABLE="width: 616"]
<tbody>[TR]
[TD="class: xl65, width: 77"][/TD]
[TD="class: xl68, width: 77"][/TD]
[TD="class: xl68, width: 77"][/TD]
[TD="class: xl68, width: 77"][/TD]
[TD="class: xl68, width: 77"][/TD]
[TD="class: xl68, width: 77"][/TD]
[TD="class: xl65, width: 77"][/TD]
[TD="class: xl65, width: 77"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl70"]Name[/TD]
[TD="class: xl69"]Physics[/TD]
[TD="class: xl69"]Chemistry[/TD]
[TD="class: xl69"]Maths[/TD]
[TD="class: xl71"]CGPA[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Abc[/TD]
[TD="class: xl65, align: right"]98[/TD]
[TD="class: xl65, align: right"]65[/TD]
[TD="class: xl65, align: right"]34[/TD]
[TD="class: xl66, align: right"]4.1[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Def[/TD]
[TD="class: xl65, align: right"]78[/TD]
[TD="class: xl65, align: right"]56[/TD]
[TD="class: xl65, align: right"]76[/TD]
[TD="class: xl66, align: right"]3.1[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl72"]Ghi[/TD]
[TD="class: xl68, align: right"]34[/TD]
[TD="class: xl68, align: right"]98[/TD]
[TD="class: xl68, align: right"]45[/TD]
[TD="class: xl73, align: right"]5.6[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl70"]Name[/TD]
[TD="class: xl69"]Physics[/TD]
[TD="class: xl69"]Chemistry[/TD]
[TD="class: xl69"]Maths[/TD]
[TD="class: xl71"]CGPA[/TD]
[TD="class: xl67"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Jkl[/TD]
[TD="class: xl65, align: right"]87[/TD]
[TD="class: xl65, align: right"]78[/TD]
[TD="class: xl65, align: right"]34[/TD]
[TD="class: xl66, align: right"]7.3[/TD]
[TD="class: xl67"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Mno[/TD]
[TD="class: xl65, align: right"]69[/TD]
[TD="class: xl65, align: right"]56[/TD]
[TD="class: xl65, align: right"]98[/TD]
[TD="class: xl66, align: right"]5.3[/TD]
[TD="class: xl67"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Pqr[/TD]
[TD="class: xl65, align: right"]94[/TD]
[TD="class: xl65, align: right"]76[/TD]
[TD="class: xl65, align: right"]45[/TD]
[TD="class: xl66, align: right"]6.5[/TD]
[TD="class: xl67"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Vxw[/TD]
[TD="class: xl65, align: right"]56[/TD]
[TD="class: xl65, align: right"]56[/TD]
[TD="class: xl65, align: right"]78[/TD]
[TD="class: xl66, align: right"]5.6[/TD]
[TD="class: xl67"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl72"]Xyz[/TD]
[TD="class: xl68, align: right"]98[/TD]
[TD="class: xl68, align: right"]98[/TD]
[TD="class: xl68, align: right"]34[/TD]
[TD="class: xl73, align: right"]3.7[/TD]
[TD="class: xl67"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl68"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl70"]Name[/TD]
[TD="class: xl69"]Physics[/TD]
[TD="class: xl69"]Chemistry[/TD]
[TD="class: xl69"]Maths[/TD]
[TD="class: xl71"]CGPA[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl72"]Stu[/TD]
[TD="class: xl68, align: right"]69[/TD]
[TD="class: xl68, align: right"]79[/TD]
[TD="class: xl68, align: right"]87[/TD]
[TD="class: xl73, align: right"]8.5[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[/TR]
</tbody>[/TABLE]
Raw Data sheet can have any number of tables in any location with each table containing any number of rows, but the table headers are the same. So i need to search using a column header, find the list of data below it and then paste it in the new sheet ("Collated"). This process needs to go on till all the instances of a particular column header data re found and pasted in Collated sheet. Also this needs to be done for all Column headers.
So my collated sheet needs to look like this.
[TABLE="width: 448"]
<tbody>[TR]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"]Name[/TD]
[TD="class: xl65"]Physics[/TD]
[TD="class: xl65"]Chemistry[/TD]
[TD="class: xl65"]Maths[/TD]
[TD="class: xl65"]CGPA[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"]Abc[/TD]
[TD="class: xl65, align: right"]98[/TD]
[TD="class: xl65, align: right"]65[/TD]
[TD="class: xl65, align: right"]34[/TD]
[TD="class: xl65, align: right"]4.1[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"]Def[/TD]
[TD="class: xl65, align: right"]78[/TD]
[TD="class: xl65, align: right"]56[/TD]
[TD="class: xl65, align: right"]76[/TD]
[TD="class: xl65, align: right"]3.1[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"]Ghi[/TD]
[TD="class: xl65, align: right"]34[/TD]
[TD="class: xl65, align: right"]98[/TD]
[TD="class: xl65, align: right"]45[/TD]
[TD="class: xl65, align: right"]5.6[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"]Jkl[/TD]
[TD="class: xl65, align: right"]87[/TD]
[TD="class: xl65, align: right"]78[/TD]
[TD="class: xl65, align: right"]34[/TD]
[TD="class: xl65, align: right"]7.3[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"]Mno[/TD]
[TD="class: xl65, align: right"]69[/TD]
[TD="class: xl65, align: right"]56[/TD]
[TD="class: xl65, align: right"]98[/TD]
[TD="class: xl65, align: right"]5.3[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"]Pqr[/TD]
[TD="class: xl65, align: right"]94[/TD]
[TD="class: xl65, align: right"]76[/TD]
[TD="class: xl65, align: right"]45[/TD]
[TD="class: xl65, align: right"]6.5[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"]Vxw[/TD]
[TD="class: xl65, align: right"]56[/TD]
[TD="class: xl65, align: right"]56[/TD]
[TD="class: xl65, align: right"]78[/TD]
[TD="class: xl65, align: right"]5.6[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"]Xyz[/TD]
[TD="class: xl65, align: right"]98[/TD]
[TD="class: xl65, align: right"]98[/TD]
[TD="class: xl65, align: right"]34[/TD]
[TD="class: xl65, align: right"]3.7[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"]Stu[/TD]
[TD="class: xl65, align: right"]69[/TD]
[TD="class: xl65, align: right"]79[/TD]
[TD="class: xl65, align: right"]87[/TD]
[TD="class: xl65, align: right"]8.5[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[/TR]
</tbody>[/TABLE]
Could someone please help me solve this.
Thanks
Aryan
I am new to VBA and i have been trying to achieve the following but i am stuck. I have different tables in one worksheet with common headers from which i need to collate the data into a single table with one set of headers, in a different worksheet. Example given below is of the Raw data sheet.
[TABLE="width: 616"]
<tbody>[TR]
[TD="class: xl65, width: 77"][/TD]
[TD="class: xl68, width: 77"][/TD]
[TD="class: xl68, width: 77"][/TD]
[TD="class: xl68, width: 77"][/TD]
[TD="class: xl68, width: 77"][/TD]
[TD="class: xl68, width: 77"][/TD]
[TD="class: xl65, width: 77"][/TD]
[TD="class: xl65, width: 77"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl70"]Name[/TD]
[TD="class: xl69"]Physics[/TD]
[TD="class: xl69"]Chemistry[/TD]
[TD="class: xl69"]Maths[/TD]
[TD="class: xl71"]CGPA[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Abc[/TD]
[TD="class: xl65, align: right"]98[/TD]
[TD="class: xl65, align: right"]65[/TD]
[TD="class: xl65, align: right"]34[/TD]
[TD="class: xl66, align: right"]4.1[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Def[/TD]
[TD="class: xl65, align: right"]78[/TD]
[TD="class: xl65, align: right"]56[/TD]
[TD="class: xl65, align: right"]76[/TD]
[TD="class: xl66, align: right"]3.1[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl72"]Ghi[/TD]
[TD="class: xl68, align: right"]34[/TD]
[TD="class: xl68, align: right"]98[/TD]
[TD="class: xl68, align: right"]45[/TD]
[TD="class: xl73, align: right"]5.6[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl70"]Name[/TD]
[TD="class: xl69"]Physics[/TD]
[TD="class: xl69"]Chemistry[/TD]
[TD="class: xl69"]Maths[/TD]
[TD="class: xl71"]CGPA[/TD]
[TD="class: xl67"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Jkl[/TD]
[TD="class: xl65, align: right"]87[/TD]
[TD="class: xl65, align: right"]78[/TD]
[TD="class: xl65, align: right"]34[/TD]
[TD="class: xl66, align: right"]7.3[/TD]
[TD="class: xl67"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Mno[/TD]
[TD="class: xl65, align: right"]69[/TD]
[TD="class: xl65, align: right"]56[/TD]
[TD="class: xl65, align: right"]98[/TD]
[TD="class: xl66, align: right"]5.3[/TD]
[TD="class: xl67"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Pqr[/TD]
[TD="class: xl65, align: right"]94[/TD]
[TD="class: xl65, align: right"]76[/TD]
[TD="class: xl65, align: right"]45[/TD]
[TD="class: xl66, align: right"]6.5[/TD]
[TD="class: xl67"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Vxw[/TD]
[TD="class: xl65, align: right"]56[/TD]
[TD="class: xl65, align: right"]56[/TD]
[TD="class: xl65, align: right"]78[/TD]
[TD="class: xl66, align: right"]5.6[/TD]
[TD="class: xl67"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl72"]Xyz[/TD]
[TD="class: xl68, align: right"]98[/TD]
[TD="class: xl68, align: right"]98[/TD]
[TD="class: xl68, align: right"]34[/TD]
[TD="class: xl73, align: right"]3.7[/TD]
[TD="class: xl67"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl68"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl70"]Name[/TD]
[TD="class: xl69"]Physics[/TD]
[TD="class: xl69"]Chemistry[/TD]
[TD="class: xl69"]Maths[/TD]
[TD="class: xl71"]CGPA[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl72"]Stu[/TD]
[TD="class: xl68, align: right"]69[/TD]
[TD="class: xl68, align: right"]79[/TD]
[TD="class: xl68, align: right"]87[/TD]
[TD="class: xl73, align: right"]8.5[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[/TR]
</tbody>[/TABLE]
Raw Data sheet can have any number of tables in any location with each table containing any number of rows, but the table headers are the same. So i need to search using a column header, find the list of data below it and then paste it in the new sheet ("Collated"). This process needs to go on till all the instances of a particular column header data re found and pasted in Collated sheet. Also this needs to be done for all Column headers.
So my collated sheet needs to look like this.
[TABLE="width: 448"]
<tbody>[TR]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"]Name[/TD]
[TD="class: xl65"]Physics[/TD]
[TD="class: xl65"]Chemistry[/TD]
[TD="class: xl65"]Maths[/TD]
[TD="class: xl65"]CGPA[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"]Abc[/TD]
[TD="class: xl65, align: right"]98[/TD]
[TD="class: xl65, align: right"]65[/TD]
[TD="class: xl65, align: right"]34[/TD]
[TD="class: xl65, align: right"]4.1[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"]Def[/TD]
[TD="class: xl65, align: right"]78[/TD]
[TD="class: xl65, align: right"]56[/TD]
[TD="class: xl65, align: right"]76[/TD]
[TD="class: xl65, align: right"]3.1[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"]Ghi[/TD]
[TD="class: xl65, align: right"]34[/TD]
[TD="class: xl65, align: right"]98[/TD]
[TD="class: xl65, align: right"]45[/TD]
[TD="class: xl65, align: right"]5.6[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"]Jkl[/TD]
[TD="class: xl65, align: right"]87[/TD]
[TD="class: xl65, align: right"]78[/TD]
[TD="class: xl65, align: right"]34[/TD]
[TD="class: xl65, align: right"]7.3[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"]Mno[/TD]
[TD="class: xl65, align: right"]69[/TD]
[TD="class: xl65, align: right"]56[/TD]
[TD="class: xl65, align: right"]98[/TD]
[TD="class: xl65, align: right"]5.3[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"]Pqr[/TD]
[TD="class: xl65, align: right"]94[/TD]
[TD="class: xl65, align: right"]76[/TD]
[TD="class: xl65, align: right"]45[/TD]
[TD="class: xl65, align: right"]6.5[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"]Vxw[/TD]
[TD="class: xl65, align: right"]56[/TD]
[TD="class: xl65, align: right"]56[/TD]
[TD="class: xl65, align: right"]78[/TD]
[TD="class: xl65, align: right"]5.6[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"]Xyz[/TD]
[TD="class: xl65, align: right"]98[/TD]
[TD="class: xl65, align: right"]98[/TD]
[TD="class: xl65, align: right"]34[/TD]
[TD="class: xl65, align: right"]3.7[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"]Stu[/TD]
[TD="class: xl65, align: right"]69[/TD]
[TD="class: xl65, align: right"]79[/TD]
[TD="class: xl65, align: right"]87[/TD]
[TD="class: xl65, align: right"]8.5[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[/TR]
</tbody>[/TABLE]
Could someone please help me solve this.
Thanks
Aryan