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]/ ---------------------------------------------------------
