Show Data from Various Tabs in one Tab within the same worksheet
 

I still am working on my Teacher test result WorkBook. The problem I
am having now is transferring data from students tab to Roster tab, I
tried to explain this in my last post but I think I failed Due to No
response, no luck, so I am trying it again.

(Roster Tab- Sheet1)
A B C D E F G H Up To BM
1
2 Name1 Data Data Data Data Data
3 Name2
4 Name3
5 Up To
42
Name

(Name1 Tab - Sheet3) Sheet 2(Template) Is Hidden all Student tabs are
copy of Sheet2

Student Tabs are all have the same format. The data points are all the
same i.e Cell's F8, F14, G25 etc. My goal is to place a code or
formula in Either Roster Tab-Sheet1 or the respected cells to show
these data points for each student, sort of overall look. So the Info
in Cell F8 of the student tab should be reflected in cell C2 of the
roster Tab =(StudentName!F8).

Any Idea of approach.

Show Data from Various Tabs in one Tab within the same worksheet
 

Hi Alok
It gives me an #REF! Error..........
http://www.pesare-darya.com/images/error-1.jpg
Ardy

Alok wrote:
Hi Ardy,
Have you tried the Indirect formula? Put this in Cell C2
=INDIRECT(A2 & "!F8")
This assumes that the student names are in A2 through Axx and that the tabs
are named by Student name.
Extend the formula from C2 to Cxx
Alok

"Ardy" wrote:

I still am working on my Teacher test result WorkBook. The problem I
am having now is transferring data from students tab to Roster tab, I
tried to explain this in my last post but I think I failed Due to No
response, no luck, so I am trying it again.

(Roster Tab- Sheet1)
A B C D E F G H Up To BM
1
2 Name1 Data Data Data Data Data
3 Name2
4 Name3
5 Up To
42
Name

(Name1 Tab - Sheet3) Sheet 2(Template) Is Hidden all Student tabs are
copy of Sheet2

Student Tabs are all have the same format. The data points are all the
same i.e Cell's F8, F14, G25 etc. My goal is to place a code or
formula in Either Roster Tab-Sheet1 or the respected cells to show
these data points for each student, sort of overall look. So the Info
in Cell F8 of the student tab should be reflected in cell C2 of the
roster Tab =(StudentName!F8).

Any Idea of approach.

Show Data from Various Tabs in one Tab within the same workshe
 

Works Like A charm,
I think I will incorporate this within my create student tab function,


Thanks a bunch.
Ardy
Alok wrote:
You probably have a space in the names - my mistake I should have guessed it
- you need to use the following version

=INDIRECT("'" & A2 & "'!F8")

Note that there is a single quote inside the first double quotes and that
there is a single quote also before the !F8. This is because when you refer
to any worksheet that has a space in the worksheet name, the worksheet name
has to be enclosed in single quotes.

Alok
"Ardy" wrote:

Hi Alok
It gives me an #REF! Error..........
http://www.pesare-darya.com/images/error-1.jpg
Ardy

Alok wrote:
Hi Ardy,
Have you tried the Indirect formula? Put this in Cell C2
=INDIRECT(A2 & "!F8")
This assumes that the student names are in A2 through Axx and that the tabs
are named by Student name.
Extend the formula from C2 to Cxx
Alok

"Ardy" wrote:

I still am working on my Teacher test result WorkBook. The problem I
am having now is transferring data from students tab to Roster tab, I
tried to explain this in my last post but I think I failed Due to No
response, no luck, so I am trying it again.

(Roster Tab- Sheet1)
A B C D E F G H Up To BM
1
2 Name1 Data Data Data Data Data
3 Name2
4 Name3
5 Up To
42
Name

(Name1 Tab - Sheet3) Sheet 2(Template) Is Hidden all Student tabs are
copy of Sheet2

Student Tabs are all have the same format. The data points are all the
same i.e Cell's F8, F14, G25 etc. My goal is to place a code or
formula in Either Roster Tab-Sheet1 or the respected cells to show
these data points for each student, sort of overall look. So the Info
in Cell F8 of the student tab should be reflected in cell C2 of the
roster Tab =(StudentName!F8).

Any Idea of approach.