Intelligent Macro for automatic row updation in excel

[Zaib]

Dear Fellows,
I am trying to make a small transaction report in excel. This report contains four coloums for calculation & some other coloumns for simple text based entries.
Number of entries in this report are change-able values. Sometimes, 10 or sometimes upto 30.
Now, I want to make a macro which can understand the number of rows and generate the result at the end of all entries.

I have made one macro but it always generates result at fixed row irrespective of the number of entries. Please guide.

[MarvinP]

Hi Zaib and welcome to the forum,

I think you are looking for this article:
http://nabeelmoeen.wordpress.com/200...cel-worksheet/