Using a template and adding to pages

**LaughAtDo0m** · 08-23-2006, 04:33 PM

Couldn't think of a better name, oh well.
First off, I know absolutely NOTHING about how Macro's work.
I'm trying to make it so that when I add another page to my worksheet, it will add a column to an existing page. However, I have a few more complex questions dealing with this:

1- Can I make it so that the template for the new page will create a new column based on its position in the sheets. For example, I have 5 sheets: Sheet1, Sheet2, Sheet3, Sheet4, and InfoSheet. Inside of Infosheet I have a table that lists code that the other four sheets rely on. I want it to be that if I were to insert a new sheet, Sheet5, inbetween Sheet3 and Sheet4, the new column created would be inserted inbetween the columns labeled "Sheet3" and "Sheet4".

2- Can I make it so that a cell is labeled after the name of a sheet (and allow it to automatically update with a sheet's namechange)? Using the previous example, if I were to relable Sheet3 as "Kyle" and Sheet5 as "Joe", then the cells in InfoSheet that say "Sheet3" and "Sheet5" would say "Kyle" and "Joe" instead.

3-(ALTERNATIVE)- Is there a way to make an application inside of a sheet that would do the previous questions without manually inserting a worksheet (which then becomes part of another page's cells)? For example, I would make a box with two cells- one that can be altered (say, a cell to enter text names) and one that says "ADD NEW PAGE" so that when text (lets pretend the text says "Doug") is entered into the first cell and confirmed by the "ADD NEW PAGE" cell/button, a new column(with a cell labeled "Doug") would appear on page "InfoSheet" and a new sheet would appear labeled "Doug" that would follow a worksheet template that was created for this file. In this one I wouldn't need the InfoSheet to do what I asked in problem number 2.

I will have a lot more questions

**LaughAtDo0m** · 08-23-2006, 04:50 PM

Yup, have a new question already. Is it possible to make a code in a template that looks for its sheet's name in another sheet for information. For example, I want some cells in sheet "Kyle" to draw information from the Cell d2, which is right under Cell d1 that was labeled "Kyle" when his sheet was made. It would say "=if(InfoSheet!d2=1, 1, 0) so that if were to enter 1 into d2 on InfoSheet the cell in sheet Kyle would update. I would like it to recognize what column it has to be drawing information from when the new sheet is created, so could the third problems's Name Cell also be used as a way to find out what cells all the cells in this page will be drawing information from?

I know I made this a little complex, so if I wasn't clear on anything PLEASE ask what I mean so that ayou can help me. I'd really like to see this work.