Hi,
I am not sure if this is simple or not but I have a table that looks something like this
cells A7:F7 contain formulas. the table need to be updated once in a while by inserting a new column, but when I do this, the formula disappears from the corresponding cell in row 7.
[/IMG]