Thank you all so much! Putting the total far below will work, so will
putting it above. Thanks Again!
--
FirstVette52


"Shane Devenshire" wrote:

Hi,

1. To put it below you could write a macro.

2. Or you could put the calculation far below the last possible extract row
and then use autofilter to hide all the blank rows between the calculation
and the last extracted value.

In the second case you can set up the autofilter and calculation formulas
before you do the extract so it only needs to be done once.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"FirstVette52" wrote:

Thank you to any who dare... this may not be possible but I appreciate your
comments.

I have an extracted range and need to add a total to the next row after its
last extracted record each time it runs.
Some times I get 2 records, sometimes 70, but in each case I need the next
row after the last record to contain a sum of all values in a given column,
but only in the extracted data (above the extracted data are the data source
records).

The Extract range always begins in cells A213:G213. A212:G212 contains the
Headings for the cells.

Thx!
--
FirstVette52