i have a sheet populated by data from a database query, parts of the rows of
data are coppied into a different sheet with a totals row at the bottom. The
problem is, the data i am using can range from 10 to hundreds of rows long,
but the totals row always needs to be at the bottom of the data (next to it).

what i really want to do is create a macro that inserts a row underneith a
row which contains values (specifically values as all rows contain formulas)
and deletes rows if the row above is empty.

i have a macro that adds a new row and fills down the formulas only from
the line above, but getting it to run to thte above specifications is causing
a problem.

Any ideas or help would be much appreiated

regards

Patrick