Hi

Formulas can't add any rows, they only can display a value in same cell they
are in - depending on parameters.

There is hard to advice anything with so sparse information - some example
of real data and formulas along with description of sheet design would be a
great help. But in general, usually there is some column in source workbook
having non-empty value whenever there are some data in row. Then you can
easily check it in target workbook. Something like this:
=IF(SourceSheet!A2="","",YourFormula)
When you have to check several cells, then something like:
=IF(AND(SourceSheet!A2="",SourceSheet!F2=""),"",Yo urFormula)
or
=IF(COUNTIF(SourceSheet!A2:C2,"<")=0,"",YourFormu la)
or
=IF(COUNTIF(SourceSheet!A2:C2,"<""")=0,"",YourFor mula)
(the last formula checks for formulas returning not an empty string)
etc.

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"Ralph Howarth" wrote in message
...
Is it possible to have Named dynamic ranges for a worksheet included in
formulas in another worksheet; but have the formulas automatically add
rows
of more formulas for each row found in the source worksheet?

I find that I simply have to replicate formulas a good swath of rows to
ensure that all source data rows are calculated while using many IF
statements to prevent empty rows of the source data worksheet from
appearing
as zeros in the formula worksheet.

I have variable rows on the source worksheet where the header row is on
row
3 and the formula worksheet has the header row on row 1.