reporting from excell workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Try VLOOKUP to lookup student in each of the four areas
best wishes
 
kool,I've got the vlookup going but how do you show multiple values?
 
More vlookups.

One for each piece of data you want returned.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set a pivot table to group quarterly reports by F/Y? 2
how to carry forward a total from one page to another 3
Combining 11 "like" workbooks... 2
Linking workbooks 1
Pivot Table Count Issue 6
Averaging cells in separate workbooks to make year-to-date average 7
add subtotals in columns in pivot table 2
Mastersheet to Worksheet data copy - macros? 1

Back
Top