Hi... Column Data to Row - Help

[deepanc]

HI.. I don't know how can I make this .. Please guide Me... please see the attcah.. I need the formula where I put red entries..
here is My problem:

I have a consolidate sheet (manual entry) which has data of 5 sheets.

now I want to use in formula to copy the data in respective sheets..
Eg: sheet "class"
No Name Sub 40 60 100

1 A
Tam 1 2 3
Eng 4 5 9
Mat 9 8 17
Sci 4 5 9
Soc 7 6 13
2 B
Tam 4 7 11
Eng 7 3 10
Mat 6 7 13
Sci 5 9 14
Soc 0 5 5

Now I want in sheet "Tam"

as

No Name 40 60 100
1 A 1 2 3
2 B 4 7 11


then sheet "Eng"

No Name 40 60 100
1 A 4 5 9
2 B 7 3 10
vice versa...


here sheet "class" manual entry, and I need the formula for other sheets to get equal data in respective sheets..
thank in advance

[JBeaucaire]

In H1 of the "name" sheets, put this formula:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)


Then in C2 put this formula and copy down and across:

=IF($B2="", "", INDEX(class!$B:$F, MATCH($B2, class!$B:$B, 0)+MATCH($H$1, class!$C$4:$C$8, 0), MATCH(C$1, class!$B$1:$F$1, 0)))

[deepanc]

Hi. thank u . It works and a small error but I adjust that. In the selection of cell range. Thank once again