I will give this a try and see what happens. I will let you know.

"ckemler" wrote:

You should consider naming your ranges. Search the help under "name" or
"range". Taking the extra time to do this when you set up your file should
take care of this.

"Shawn" wrote:

I am referencing a column from a seperate sheet within one file. The problem
I have is that when I insert a column my formulas are not updating properly
on the seperate sheet. An example of my formula is
"countif(Sheet2!F$3:F$500,B11)". I need the formulas to find the critera one
column at a time. When I need to insert a column on sheet 2 the column
numbers referenced in the formulas change from A,B,C,D,etc to A,B,D,E etc.
Basically, as I drag and copy across a range with a formula the columns
originally format properly within the formula but, when I go back and insert
a column on other sheet the formulas will not automatically update correctly.