stevechapman said:I think, what I am asking, can you make the Formulas so they cell reference themselves, without me going through and changing the things a million times?
So all I do, is paste the Formula, into every E-Mail address cell and thats it, cell references itself.
Make this Formula cell reference itself...
=CONCATENATE(E2,COUNTIF(E$2:E2,E2))
The same with Echos Formula too...
=LOWER(CONCATENATE(D2,RIGHT(C2,2),LEFT(A2,1),LEFT( B2,1)))
Thanks guys
When you copy and paste, you should copy the cell as a whole and not the contents (from either the cell or formula bar depending on your settings).
However you should use Excel's own FILL function to fill large groups of cells. The FILL function automatically changes cell references, unless they're preceded by a $ sign.
To do this with your sheet;
1. Enter the formulas at the top of the columns.
2. Starting with the cells containing the formulas, select the cells below.
3. from the menu, Edit -> Fill -> Down, or just press CTRL-D
You will see that the row references will have changed automatically.