[mso] Excel Subroutine

Folks,

If you can help, I'll dance at your wedding, relatives wedding, or just dance 
in general.

I have developed a program in MS Excel 2003 that automatically performs every 
single manual task that is required to maintain my company's golf league, but 
at present it's tons of memory.  We have 182 members and 18 teams, and the 
program has to keep up with each individual, each team, and each tournament (20 
per season).  A lot of work for the program, i.e. a lot of memory, since each 
formula has to be repeated over and over for each member, team, etc.  But if I 
could figure out how to build a single cell that only acts as a subroutine to 
satisfy the hundreds of cells that require that same formula, the program would 
be much more generous and I could develop it even further.

What I'm saying is:  say Paul , John, George, and (heck) Ringo play as a 
foursome.  Each requires the same formula to acquire his weekly handicap.  Is 
there a way to task this function to a single "subroutine" cell and paste the 
result for each golfer, rather than repeating the same function four times?

Thanks


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: