Macro Optimization - Include Sum in last row of data

Dear All,

Can you please see my attached workbook and advise? I have included in the workbook the macro I'm using, which is 'imperfect' because I'm forced to make the table till the 200th row so as to include every time all the data (they usually range up to 200 rows) for the sum. Please have a look and advise how can I instruct excel to create the Sum under the last row which varies every time.

Thank you very much
ilias

hi iliasark, please check attachment if that helps, unnecessary code lines have been commented out

Originally Posted by watersev

hi iliasark, please check attachment if that helps, unnecessary code lines have been commented out

THANK YOU 'waterserv'!!
This did the trick..by the way, without being in the VBA code, how this would be translated in normal excel selections/functions? (the part of the sum every time under the last row..)

without VB you could use Subtotal built-in feature that will make outline and input total row for a group of data if the data groups can be differentiated

Originally Posted by watersev

without VB you could use Subtotal built-in feature that will make outline and input total row for a group of data if the data groups can be differentiated

yes indeed!(tested that way as well) so as to understand the logic behind as I'm really on my first steps on VBA...100% covered! :-)