Hi MSP77079,

Thank you for reply. Apologies, if the question was not clear.

The data is being filtered by Advanced Filter using different criteria


It is not that I want to know how to find out the last row in th
worksheet I just pasted to, but rather, how to automate the placing o
totals on that worksheet to avoid them being overwritten each time th
number of rows of filtered data changes. I want to place the Formul
Totals two rows after the last row of filtered data is pasted. Th
Formula for the totals will be in the Macro. I want to avoid th
totals being overwritten each time the number of copied rows/ record
changes. I do not want to manually shift the rows up or down, as th
case may be each time.

Based on the above which of your solutions do you recommend and ho
would I actually tack on the placing of the totals to one of th
solutions.

Thank you.
QT

--
Message posted from http://www.ExcelForum.com