Auto refresh excel functions

[Revathi kannan]

Hi all,

> I have a source data in sheet 1 and i have implemented excel functions in sheet 2 (Eg. Sum, Sum if, Lookup).

> Currently i have source data from Range A3 to H8 but in future the range will change to A3 to H15.

> Is there any possible ways in VBA to refresh the excel functions automatically. Attached reference data.

This will help me a lot.

Please assist me.

[TMS]

You don't really need VBA for that. You could use Dynamic Named Ranges. Or, maybe convert your data to a Structured Table.

[Revathi kannan]

i have named the range of my source data.. but my formulas are not working after inserting my named range into it.

[TMS]

i have named the range of my source data.. but my formulas are not working after inserting my named range into it.

What does your Named Range formula look like? What do you mean by "not working". Does it just still refer to the original range ... in which case it is probably not Dynamic ... or does it give you an error message?