creating a new sheet that automatically fills a new column in.

[rochea]

Hi all,
i want to know if there is a way, when i create a new sheet in the excel document, that excel then automatically fills in a column on another sheet. hope this makes sense, the sheet i want it to fill the column on is the 'Graph matrix' sheet

[alansidman]

1. Are you creating the new sheet using VBA? Manually?
2. When the new sheet is created, what column of information on the Graph Matrix Sheet should be copied?
3. Where should the information copied be pasted in the new Sheet? Name of new Sheet?