Hi Excel Forum,

Hope you can help.

I am working with filtered data that will be copied to anothe
worksheet (via a macro procedure). The first row of data is Row Numbe
4, the column is C.

How can I automate the calculation of a total to be placed on th
worksheet (after the copying process) without knowing the final / las
Row Number of copied filtered data -- this will vary: Row Number canno
be fixed/ hard-coded?

How can I sum the values from Row Number 4 to whatever Row Number hold
the last data and place a total two rows below the last row of data?

Please provide a working example.

Thank you
QT

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