Automated table?

Copper Contributor
Hi guys I'm new here and I would like to ask something about table
Can i make a table which automated resize it's total number of row based on a specified cell?
For example, the size of table is determined by :
=$A$3:$D$7
And at cell A1 I have "12"
It is a fixed table, is it possible to make the $D$7 reffers to cell A1 and become $D$12 ?
Pardon my bad english, i'd love to hear your suggestion,
Thanks
1 Reply

@Diptabas 

You could use the INDIRECT function:

 

=INDIRECT("A3:D"&A1)