reporting from excell workbook
 

I have created a multi-sheet workbook for a school teacher. It has all
students for each quarter, with quarter,semester,half-year and yearly totals.
What I also need to do is generate a single student report for the each of
the above. How is this possible to do? I am familiar with macros, and most
fomulas, name tables but not pivot tables. thanks

reporting from excell workbook
 

Try VLOOKUP to lookup student in each of the four areas
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"acomputer4u" wrote in message
...
I have created a multi-sheet workbook for a school teacher. It has all
students for each quarter, with quarter,semester,half-year and yearly
totals.
What I also need to do is generate a single student report for the each of
the above. How is this possible to do? I am familiar with macros, and most
fomulas, name tables but not pivot tables. thanks

reporting from excell workbook
 

kool,I've got the vlookup going but how do you show multiple values?

"Bernard Liengme" wrote:

Try VLOOKUP to lookup student in each of the four areas
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"acomputer4u" wrote in message
...
I have created a multi-sheet workbook for a school teacher. It has all
students for each quarter, with quarter,semester,half-year and yearly
totals.
What I also need to do is generate a single student report for the each of
the above. How is this possible to do? I am familiar with macros, and most
fomulas, name tables but not pivot tables. thanks

reporting from excell workbook
 

I did the vlookup but how do you show more than one cell!!!

"Bernard Liengme" wrote:

Try VLOOKUP to lookup student in each of the four areas
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"acomputer4u" wrote in message
...
I have created a multi-sheet workbook for a school teacher. It has all
students for each quarter, with quarter,semester,half-year and yearly
totals.
What I also need to do is generate a single student report for the each of
the above. How is this possible to do? I am familiar with macros, and most
fomulas, name tables but not pivot tables. thanks

reporting from excell workbook
 

More vlookups.

One for each piece of data you want returned.


Gord Dibben MS Excel MVP


On Wed, 8 Nov 2006 15:03:01 -0800, acomputer4u
wrote:

I did the vlookup but how do you show more than one cell!!!

"Bernard Liengme" wrote:

Try VLOOKUP to lookup student in each of the four areas
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"acomputer4u" wrote in message
...
I have created a multi-sheet workbook for a school teacher. It has all
students for each quarter, with quarter,semester,half-year and yearly
totals.
What I also need to do is generate a single student report for the each of
the above. How is this possible to do? I am familiar with macros, and most
fomulas, name tables but not pivot tables. thanks