PDA

View Full Version : Amend Macro Store Info In Different Places



jord2323
04-07-2011, 10:35 AM
Hi,

I am wondering if anyone could help me.

I am trying to get this macro to store information held in a form I have created in two different places on another sheet.

The idea is that the user would enter a name, select a group and enter a MEG. The group would determine where the student is saved.

There also needs to be a limit on how many students can be added into each group, so when one group is full an error message will be displayed and that student not added.

I have attached the file.

The notes are in "Add Late Student" sheet.


Thanks

Jord

Bob Phillips
04-07-2011, 02:51 PM
I can't say I really understand your problem, but ... you don't have to store each procedure in its module, you can have many per module.

Bob Phillips
04-07-2011, 02:53 PM
And ... clicking 'Add New Student' on 'Main Menu' throws up an error.