Thanks Polly..... I'm inserting my spreadsheet so that you can see what I mean.
Caroline <<Registration Template>> > ---------- > From: Polly Saxton > Reply To: [EMAIL PROTECTED] > Sent: Thursday, June 12, 2003 1:14 PM > To: [EMAIL PROTECTED] > Subject: Re: [info-tech] Excel Question > > Caroline~ > I don't know without looking at your spreadsheet but you might be > able to use a Macro in this situation. I'm not sure about using > macros and templates but you could try it. > Let me know if you would want to use this solution and have questions, > Polly > > > > >Hello everyone! Hope summer is going well..... > > > >I have an Excel spreadsheet that I want to use as a template during > >registration. But, there is a problem: > > > >I have info in column A, (which will not change). > >Column B will be filled in as parents come in and register. (Students > name, > >book fees, etc.) I have formula's set up in column B in two cells. > >When the current parent is finished and walks away, I need to Insert a > new > >column B so that the previous colum B becomes Column C, then D, then E, > etc. > >etc. as new parents come along. Here's the problem: When I insert > a > >new column B, the formula's move on with what is now "column C." Does > >anyone know of a way to force my formula to remain a constant in the > cells > >in column B? > > > >Thanks for your help!!!!!!! > > > >Caroline Thompson > >Humboldt > >--- > >[This E-mail scanned for viruses by Declude Virus on the server > >aea8.k12.ia.us] > > > >--------------------------------------------------------- > >Archived messages from this list can be found at: > >http://www.mail-archive.com/[EMAIL PROTECTED]/ > >--------------------------------------------------------- > > > -- > Polly Saxton, Office Associate for Technology > Arrowhead AEA Technology Center > 1407 Tower Drive > Fort Dodge, IA 50501 > Phone: 515-574-5534 > Fax : 515-574-5336 > e-mail: [EMAIL PROTECTED] > > ~~A Smile Can Be Contagious! :)~~ > --- > [This E-mail scanned for viruses by Declude Virus on the server > aea8.k12.ia.us] > > --------------------------------------------------------- > Archived messages from this list can be found at: > http://www.mail-archive.com/[EMAIL PROTECTED]/ > --------------------------------------------------------- > >
Registration Template.XLS
Description: Registration Template
