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.