Hi to all
I am creating macro application.
I have a sheet with few columns, Below is the format of sheets.
Class Subject Kiran Rahul Mary Susan
X Language1 85 45 60 94
X Language2 80 40 60 95
X Maths 60 42 60 92
X Physics 45 43 60 91
X Chemistry 35 75 60 90
X Biology 60 60 60 92
I need to create new sheet based on column header from Column C, so new sheet will be Kiran, Rahul, Mary and Susan.
And i need data from Column A and B common in all sheets, and respective column. For example Susan sheet will be like below.
Class Subject Susan
X Language1 94
X Language2 95
X Maths 92
X Physics 91
X Chemistry 90
X Biology 92
Any suggestion, I have attached sample file as well.
I am creating macro application.
I have a sheet with few columns, Below is the format of sheets.
Class Subject Kiran Rahul Mary Susan
X Language1 85 45 60 94
X Language2 80 40 60 95
X Maths 60 42 60 92
X Physics 45 43 60 91
X Chemistry 35 75 60 90
X Biology 60 60 60 92
I need to create new sheet based on column header from Column C, so new sheet will be Kiran, Rahul, Mary and Susan.
And i need data from Column A and B common in all sheets, and respective column. For example Susan sheet will be like below.
Class Subject Susan
X Language1 94
X Language2 95
X Maths 92
X Physics 91
X Chemistry 90
X Biology 92
Any suggestion, I have attached sample file as well.