Macro?
 

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

Macro?
 

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

--
__________________________________
HTH

Bob

"diana" wrote in message
...
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

Macro?
 

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


On Wed, 11 Mar 2009 06:40:05 -0700, diana
wrote:

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