Dynamic Name Ranges

Hi Martina,

Thank you for the forum question,

Dynamic ranges can be very useful. We do not need to update our functions, pivot tables and other tools, when we add more records to our tables.

You need to use a combination of the OFFSET function and one or two COUNTA functions.

I have attached a worksheet with examples.

You will need to create the dynamic range names from the NAME MANAGER on the FORMULAS tab. You will need to tart with the OFFSET function but have a look at the attached workbook.

Please let me know if you have questions to my examples.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector