=OFFSET(summary!$A1,,,COUNTA(summary!$A:$A),COUNTA (summary!$1:$1))

This works PROVIDING cells in Column A and row 1 have no embedded blanks.
Also assumes A is longest column.

Change "Summary" as needed


"M&M" wrote:

Hi, I have a named range in which I have some values. However this range will
be changing all the time. Maybe will increase in number of colums and rows
maybe decrease depending on the inputs of the user.

How can I make it so that the range remains named "Data" and changes in size
when the user inputs values?