Dynamic named ranges and updating where formulas pick from

[Muammar]

Hi all,

Assuming I have formulas that pick a set of data from the first to the last row and I want to add a new set of data, is it possible to make sure all the formulas I am applying to the original set pick the new data, i.e. as opposed to changing them manually?

Kindest Regards
Muammar

[NBVC]

There are several ways to create dynamic named ranges:

Here is one:

http://www.contextures.com/xlNames01.html#Dynamic

[Muammar]

Okay thanks. Will try it out and get back to you.