[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

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

Ardy

12/12/2006 10:34:00 PM

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.
3 Answers

Ardy

12/13/2006 6:58:00 AM

0

Hi Alok
It gives me an #REF! Error..........
http://www.pesare-darya.com/images/e...
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.
> >
> >

alok

12/13/2006 12:08:00 PM

0

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/e...
> 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.
> > >
> > >
>
>

Ardy

12/13/2006 8:36:00 PM

0

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/e...
> > 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.
> > > >
> > > >
> >
> >