Macro?

D

diana

This may sound like a stupid question, but I'm a noob to VBA. So sue me.
(Actually, please don't -- :O !)

Anyway, I teach little kids English and am compiling all their information
(grades, behavior, etc.) into an Excel file (separate sheets of course) --
what I want to do is create a new "Individual" worksheet where I can just
type in the student's name, click a 'button' and have all their information
populate into that sheet (Their grades per assignment/test/total, graphical
representation, etc.). Do I have to create a macro to do this? If so, I'm
screwed because I've never had to use VBA before...

Help? 0:]

Diana
 
B

Bob Phillips

A macro would probably be the best fit, but we would need some details of
the sheets and the data to help further.
 
G

Gord Dibben

Why "separate sheets of course"?

Keep it all on one sheet and use Excel's built-in filters to pick out
individual student data.

Allows for sorting, filtering etc.

You might find it easier than maintaining and constantly updating individual
sheets.


Gord Dibben MS Excel MVP
 
Top