Dynamic data ranges

Hello Marc,

Thank you for your question. The easiest way to make a dynamic data range is to format an empty or an existing data range as a table (Home - Styles - Format as Table).
Afterwards, by dragging the tiny blue corner of the last cell downwards or sideways, you can dynamically add rows or columns to your table.

The advantage of formatting as a table is that it behaves like a named range and you can use it in functions. It has an absolute cell reference and you can link to it from other sheets in the workbook.

I hope this helps.

Kind regards
Marius Barnard
Excel Trainer