I have two worksheets in my file (Excel 2000) that
automatically refresh (from a Microsoft Query) when a
particular cell (input criteria) is changed. I would like
to add a total row at the bottom of both sheets that sums
the data in columns F thru U. The number of rows is
variable based on which criteria is selected for the query
results. Ideally, I would like a blank row and then the
total row at the bottom. I would also like this to be
automatically triggered by the changing of my criteria
cell if that is possible with a macro.

Thanks in advance for any advice.
Laura