Displaying a Sum/Avg Formatted Value 4 a Changing Range just below the Range with VBA

Displaying a Sum/Average Formatted value for a Changing Range just below the Range using VBA

Dear Forum,

In my File, I have a sheet which acts as a View by changing the Dropdown the Size of the Data changes Row-Wise though the column remains the same its the Height which keeps on changing all the time depending on the data selected in the dropwdown.

This data is based on the concept of MultiLookup and is working fine, however I intend to make copies of this data in other sheets which are just values..

With great help from the Forum, I have managed to do that now but I am not sure how Do I take a Sum of a Dynamic Range in which the Lower Range keeps on changing and also displaying this SUm exactly below the Range which is Summed..

I also would need a Particular Formatting for this..

Like the Font Size would be 14
Format of the Summed value would be as below:

Please Login or Register  to view this content.

Font Colour = Dark Blue
Font = Bold

Borders = the Top should be Medium Thick Line and the Bottom should be 2 UnderLines commonly used to show Totals..

It would be typically look like this..
3 Row Data
ULIP-- 0.06-- Rs 5,000
ULIP-- 0.06-- Rs 10,000
ULIP-- 0.06-- Rs 10,000
---------------------> ----------------
x The Total x Rs 25,000
---------------------> =========

I need the help in VBA to display this sum as well as calculate the sum,
Hope I can use the same approach to calculate other values such as MIN,MAX,AVERAGE..

Warm Regards
e4excel

Please find the attached file for reference:

There are several sheets generated out of the Main Sheet "Family Date Picker" which acts like a View Sheet and is based on MultiLookup Concept to extract data for different criterions..

As the data is different for each criterion the Range of Data varies RowWise and therefore diaplaying a Total just belwo the Data is a veruy Big Challenge...

I know its not possible with Formulas and can only be achieved with VBA..
So please go thru the different SHeets where the Totals are mentioned I want the Total to be shown in thecell just 1 cell below the Range in the given Format..

I have used this file for other queries as well but now I need the help on dispalying a summ value with the format in the particular cells which keep on chnging...

Regards
e4excel

Please Login or Register  to view this content.