Actually, I apologize, my formula on the different sheet is not a COUNTA
function (it was previously, but I had to change it). It is an array
function. I've posted it below. When I have a formula in Column A on the
first sheet on the next available row, this formula (below, from the separate
sheet) no longer works.

{=INDEX('Marketing
Letters'!B:B,SMALL(IF(Data=$D$10,ROW(Data)),ROWS(D $10:D10)))}

Is there a way to make the first sheet respond as such:

When data is entered in the next available row in column E, that the correct
formulas and formatting are entered and applied to the cells in the rest of
the row?

"Wouter HM" wrote:

Hi Stacie,

What yo u coulf try is making your formulas a bit clever, if you did
not do so.
Let us say you have in your A column a formula

=myFormula(E2,G2,H2)

Ic cound be

=IF(ISEMPTY(E2),"";myFormula(E2,G2,H2))

A COUNT on column A will not include those rows whithout a value in
the E column, since the COUNT formula only includes numeric values.


HTH,

Woute
.