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